How to show the price of items in different currency?

[siamandm]

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

[burrina]

I think you just need to change the forms format to currency
also you might need to change the region setting in your table.

[siamandm]

Thank s for the reply
My concern is will the currency exchange rate will be saved as it will be changed daily

[burrina]

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.

[HansV]

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.