Formatting a Query Field as Currency

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a report based on a query. One of the fields on the
report is a field calculated by the query. The field used
by the query to make the calculation is defined in the
table as a currency. When I look at the properties for the
field in the report the Format drop-down is empty. Any
suggestions on how I can get the field to format as a
currency field? Thank you.
 
Ken,

Wrapping the field in a CCUR did the trick. For some
reason typing Currency in the Format field did not do
anything.

David
 
Back
Top