Desktop services template changing currency to pounds from dollars (1 Viewer)

Day101 · Nov 14, 2013

How would I go about doing this?

MarkK · Nov 14, 2013

Hey, welcome to the forum.

Multiply by the exchange rate.

Day101 · Nov 15, 2013

Sorry but I'm family new to access, been a few years from when I last did a database. Anyone just give me a idiot proof guide please sorry.

David R · Nov 15, 2013

Re: Hey, welcome to the forum.

Multiply by the exchange rate (in a query, probably).

Where do you store/access/know what the exchange rate is, to do your calculations?

Day101 · Nov 15, 2013

I'm using the template you can download from office online desktop services template, which basically gives me an invoice system. In the total amounts at the bottom when it brings up as $ sign when all I need it to be is a £ sign.

EternalMyrtle · Nov 16, 2013

Where are you trying to do this? Form, report, query, table? If table, open in design view and make sure data type is currency. Go to general tab select "Euro" under format. See attached image.

Hope this helps.

Simon_MT · Nov 17, 2013

I think you are better if you are using more than one currency to store values and their Currency and cross-reference to a Currency file or allow dynamic Exchnage Rate and store this rate or a combination of the two. You can have a feild denoted as cuurency for differing currencies as currency only looks at the (global) regional settings.

Simon

Desktop services template changing currency to pounds from dollars (1 Viewer)

Day101

New member

MarkK

bit cruncher

Day101

New member

David R

I know a few things...

Day101

New member

EternalMyrtle

I'm still alive

Attachments

Simon_MT

Registered User.

Similar threads

Users who are viewing this thread