Formatting a Query Field as Currency

[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 Snell]

Type the word Currency in the dropdown box.

 

[Ken Snell]

Alternatively, wrap the calculated field's expression with the CCur
function.

 

[David]

Ken,

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

David