Access

The UK's most regular instructor-led training courses.
Training information: ms+access+course/ · Access training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

Access

Tp has attended:
Access Introduction course

by - delegate Tp [1 post] (2008 Jun 18 Wed, 16:41) Reply

What is the best way of handling multi-currency transactions in Access?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
Full Schedule: See all 48 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Access

by - delegate Mark silver contributer [50 posts] (2008 Jul 5 Sat, 23:40) Reply

Hello TP,

It sounds like you will need a field which designates the currency type against each currency entry. I would suggest having a look-up table to store the currency types by name and symbol, ie a field for each of these two within the look-up table. Then a third field in this table could be for conversion rates. If you need to keep the conversion rate that applied at a particular date and time (eg for a transaction or sale etc) then you will need for the conversion rate to store against each such record--by having a field in the table that stores details of such transactions). If you do enter conversion rates in to a form you set up for the purpose then you can have date and time against your entry to go in automatically by having and additional time field with a default value of Now()

If you need a reminder on how set up a look-up just reply so and I (or someone) will reply again.

Regards, Mark

· When Is Microsoft Access Not The Best Choice For Your Business?
· Microsoft Access: Unleash the True Potential Today
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Innovation with Microsoft Access
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training

Please browse our web site to find out more about
ms+access+course/ and other Microsoft training courses.

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips