Yes. That'll do. ;-)
It's working. Have a fantastic weekend Bill.
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, June 15, 2018 7:40 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Format in iif statement in query
Hi Liz - Is this what you are looking for?
Format([myDecimal],"0.00%")
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
Pros, I want to put the numeric values in percentage or at least rounded by 2 and multiplied by 100 and get this only where the long decimals are have percentages.
Summary
SumOfSSCostPlusFreight
SumOfProjectCostPlusFreight
SumOfTotalProjectSavingsThisSupplier
FirstOfLeadTimeWeeks
Reduction
53926.93
2804200.36
0
Benchmark
43461.54
2260008.14
544192.22
2
0.1940632444680236757404881012
31674.94
1647105.74
1157094.62
10
0.4126290818962736314604852272
Here' s my SQL with the Supplier not showing for privacy reasons.
SELECT SummaryWOReduction.Supplier, SummaryWOReduction.SumOfSSCostPlusFreight, SummaryWOReduction.SumOfProjectCostPlusFreight, SummaryWOReduction.SumOfTotalProjectSavingsThisSupplier, SummaryWOReduction.FirstOfLeadTimeWeeks, IIf([Supplier]="Current","Benchmark",(DSum("SumOfProjectCostPlusFreight","SummaryWOReduction","Supplier='Current'")-[SumOfProjectCostPlusFreight])/DSum("SumOfProjectCostPlusFreight","SummaryWOReduction","Supplier='Current'")) AS Reduction
FROM SummaryWOReduction;
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com><mailto:Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>>
rockwellcollins.com<http://www.rockwellcollins.com/>
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar