Percentage

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hey...

How can i change the values in my querie to be expressed as a
Percent....
This is what i have already... but i need it to be expressed as a %...

% Uptake: [No Meals]/[Possible Meals]

thanks

fiona
 
Fie said:
Hey...

How can i change the values in my querie to be expressed as a
Percent....
This is what i have already... but i need it to be expressed as a %...

% Uptake: [No Meals]/[Possible Meals]
Click to expand...


% Uptake: [No Meals]/[Possible Meals] * 100

Tom Lake
 
yeah but that expresses it as 7 dec places...when i use the query for
the graph in my report... how u i change the format?
 
Fie said:
yeah but that expresses it as 7 dec places...when i use the query for
the graph in my report... how u i change the format?
Click to expand...

For two decimal places, use this:

% Uptake: Format([No Meals]/[Possible Meals] * 100, "###.00")

for more or less, change the number of 0's after the decimal point.

Tom Lake
 
Back
Top