currency format

[Guest]

I have a calculated field in a query using the Choose function e.g.
Rate:Choose(numval,Rate1,Rate2,Rate2). The three fields in the list, from a
table, are in currency format. On running the query the Rate field displays
as 0.0 format (the 2nd decimal place is not displayed if zero) On the report
using this query the Rate control cannot be set to currency, the drop list in
Format property is blank. It makes no difference if I set the field to
currency format in the query. This is Access 2000.
Any thoughts would be greatly appreciated.
Rgds

 

[Allen Browne]

Try typecasting the query field, i.e.:
Rate: CCurNz((Choose(numval,Rate1,Rate2,Rate2), 0))

For more info, see:
Calculated fields misinterpreted
at:
http://members.iinet.net.au/~allenbrowne/ser-45.html

 

[Guest]

Try:

CurRate:CCur(Nz(Choose(numval,Rate1,Rate2,Rate2), 0))

which results in Currency type.

HTH
Van T. Dinh
MVP (Access)

 

[Allen Browne]

Should be:
Rate: CCur(Nz(Choose(numval,Rate1,Rate2,Rate2), 0))