automatic currency value retrieval

[Kurt Carabott - KC]

My Problem is that i have several fields of currency ..and i wish that when
entering for example the Dollar Currency in one field, the Euro value will
appear automatically in another field and vice versa. So i think its like a
kind of linking of fields we a mathematical filter linker in the background.

Is anyone able to help me?.. Refer to me by my nickname - KC

 

[Jeff Boyce]

If you are saying you have multiple fields in your table, step back. That's
what you'd need to do in a spreadsheet, but you're using Access, a
relational database.

Instead, if you have a conversion table (x euros per dollar), a simple query
or even a DLookup and calculation returns the corresponding value. I hope
that you are working in forms, as tables only serve as "data buckets", and
don't really have the capabilities that forms do for display...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/