Format

[Fie]

In my query am trying to do a claculation, but how do i get the format
to express the answer as a %...

query is........... %Uptake: [ No Meals]/[Poss Meals]

 

[Michel Walsh]

Hi,


Format the result where you need to show the result (ie, in the form, or in
the report).


? format(0.1266, "percent")
12.66%


Alternatively, in the query designer, select the column corresponding to
your computed expression, right click to get the properties, the second line
preset "Format", select Percent.


Finally, if you really cannot do otherwise, compute

[%Update]: Format( [ No Meals]/[Poss Meals], "percent" )


Note that then, the result is a string, NOT a number anymore.


Hoping it may help
Vanderghast, Access MVP