currency format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try:

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

which results in Currency type.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top