Multiple Currencies in Access

Get help on databases - MySQL, Oracle, Access, etc.
Post Reply
I34z1k
Registered User
Posts: 8142
Joined: 05 Dec 2003, 02:00
Location: Dry Ice factory

Multiple Currencies in Access

Post by I34z1k »

Hey guys

Doing an I.T project for school. Anyone know how to use multiple currencies without using fields as numbers?


Thanks
Mike
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Post by Tribble »

Um currency is a number. lol

You could just create a mask to make text look like a number with the required currency symbol. This works as long as you don't have to do calculations. But then you could always use VBA to convert them to numbers later.
Image
Post Reply