Queries...

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

Fie

iv done a querie and the calcualtion av done is......
% uptake: [No meals]/[poss no meals]* 100 ............. the *100 is
just to get it to percentages but its got it formatted to 10 dec.plcs
is there anyway i can change this or just get the answer to change to %
without doing the *100

HELP
 
are you displaying this data in the form? because if you are, you can
just format the number there with a little VBA code. if not, then in
the back end, you can go to the design of the table, and under the
properties, put the display as a percent.
hth
 
Fie said:
iv done a querie and the calcualtion av done is......
% uptake: [No meals]/[poss no meals]* 100 ............. the *100 is
just to get it to percentages but its got it formatted to 10 dec.plcs
is there anyway i can change this or just get the answer to change to
% without doing the *100
Click to expand...

Most of the time, "percent" is just a format you apply to the raw
result. In a form or report, leave the field calculated as

% uptake: [No meals]/[poss no meals]

but set the Format property of the text box bound to that field to
"Percent". You can also use the property sheet to set the number of
decimal places you want to display.

If you plan to display the query directly as a datasheet, you can select
the calculated field in the query design grid, open its property sheet,
and set the Format property of the field to "Percent".

If you really need to, you can cause the field to be calculated as a
formatted percent string, like this:

% uptake: Format([No meals]/[poss no meals], "Percent")
 
Back
Top