Hello all,
If i have a continues form for selling items, contains item name, price in dollar , qty
At the end of the form show total in dollars , i want to show the total in GBP £ as well for example
For this purpose i have add a text box to manually add the price of dollars vs GBP for that day.
But i think this not the correct way
And in another form i would like to show the price in GBP
For such scenario what should i do please.?
Regards
How to show the price of items in different currency?
-
- BronzeLounger
- Posts: 1226
- Joined: 01 May 2016, 09:58
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: How to show the price of items in different currency?
I think you just need to change the forms format to currency
also you might need to change the region setting in your table.
also you might need to change the region setting in your table.
-
- BronzeLounger
- Posts: 1226
- Joined: 01 May 2016, 09:58
Re: How to show the price of items in different currency?
Thank s for the reply
My concern is will the currency exchange rate will be saved as it will be changed daily
My concern is will the currency exchange rate will be saved as it will be changed daily
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: How to show the price of items in different currency?
Not sure I understand your setup.
Will your database be using both US currency and GBP formats?
Or are you just converting some existing or imported formats?
Do you have an exchanged rate field in your database?
3 fields needed. 1 for US currency, 2 for GBP currency and 3 for exchange rate!
Please explain.
Will your database be using both US currency and GBP formats?
Or are you just converting some existing or imported formats?
Do you have an exchanged rate field in your database?
3 fields needed. 1 for US currency, 2 for GBP currency and 3 for exchange rate!
Please explain.
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to show the price of items in different currency?
You could create a currency conversion table with 2 fields: a date field and a number field.
Each day, enter the current date in the first field and the exchange rate in the other one.
You can calculate the price in GBP in a query based on your sales table and the conversion table, joined on the date fields.
Each day, enter the current date in the first field and the exchange rate in the other one.
You can calculate the price in GBP in a query based on your sales table and the conversion table, joined on the date fields.
Best wishes,
Hans
Hans