D
doyle60
I have the following in a union query as one of the fields:
Format(Year1Qrt1MU,"Percent") AS [Qtr 1 %]
How do I get it to return only one decimal instead of two, as seems to
be its want?
Also, I have another field:
Year1Qrt1EV AS [Qtr 1 Sales]
How do I set it to return in Standard format with no decimal places?
I couldn't find the answer by googling, surprisingly,
Thanks,
Matt
Format(Year1Qrt1MU,"Percent") AS [Qtr 1 %]
How do I get it to return only one decimal instead of two, as seems to
be its want?
Also, I have another field:
Year1Qrt1EV AS [Qtr 1 Sales]
How do I set it to return in Standard format with no decimal places?
I couldn't find the answer by googling, surprisingly,
Thanks,
Matt