Format Field as Currency

[LHolden]

I'm currently building a Query which will be used to produce Invoices in the form of a report. The query has 4 fields: Client, CoveredJan, CoveredFeb, CoveredMar, and Fee. Following these fields is an expression, TotalBill =([CoveredJan]*[Fee])+([CoveredFeb]*[Fee])+([CoveredMar]*[Fee])

My only issue so far is that I cannot figure out how to get the expression field to produce a number in the form of currency.

Thanks for any and all help!

 

[vbaInet]

If you're in the Query Designer, right-click the column and click the Properties sheet. In there you will find the Format property and in the list you will find Currency.

Otherwise, do it on the property of the control (e.g. textbox) that will be bound to the field.

 

[LHolden]

Thanks a bunch!

 

[vbaInet]

No problemo!