Bogus Currency Formatting?

[r. howell]

I have a field in a query which I developed with a switch statement. Based
on the values in one field, the switch statement is picking up currency
amounts from a variety of different fields. The switch is working just fine
in terms of picking up the amounts, but it is not picking up the currency
formatting. So I tried to format the field in the query. The field now
claims to be formatted as Currency, if I check under "Properties". But it
still is not, in fact, formatted as currency. When I insert the field into a
table, the table also claims this field is formatted as currency, but no
currency shows.

Can anyone help? Many thanks if you can.

 

[Duane Hookom]

Next time please post the Switch() statement. I expect that you only need to
wrap your statement inside Val(Switch(...)). You can then apply any
formatting you want.