Changing format to % for a calculated field

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am trying to change my format of a calculated field. I
have a field called Difference which is calculated by the
formula (2005Sales-2004Sales)/2004Sales. 2004Sales and
2005Sales have currency as the format. I want the
Difference field to be a percentage rather than a number.
However, When I go to the properties of this field both
in my report and my query both formats are blank. I need
to keep this as a calculated field for my query as well.
There is no apparent choice of percentage for my
calculated field. Any ideas about this?

Thanks,

Chuck
 
Is the fields control source from the query? If so try making a new unbound
textbox use the textbox names in the report (make sure they dont conflict
with the query) or query fields in the text box to calculate difference. You
should now be able to use format.

HTH
Martin J
 
Chuck,
In the Format property of your calculated field, select Percent (or type
it in) from the Format drop down.
Or just use a custom Format of...
#.0 %
If the results of your calculation were .55 then it would display as 55.0
%
hth
Al Camp
 
Back
Top