Currency in Access

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I am trying to produce an invoice report which can be in
either $ 0r £. It does not have to have a conversion
factor.

I can not find a way of being able to do this.

Can you help?

Thanks
 
Hello,

I'm not sure which version of Access you are using but you can
change/select the datatype of the field to Currency. This valid with
Access 2000, 2002 and 2003. You can also use the Format function in a query
to convert the field containing number to currency.

Hope this helps!

Ki
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula for currency or Macro help. 0
Access My Expression Contains Wrong number of arguments 0
Format Currency 2
How do I invoice a cost to a custom built MS Access Accounting Database? 0
How can we produce an invoice from an Excel spreadsheet? 1
best practices.rounding 17
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Access variable string for export 0

Back
Top