By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,388 Members | 1,186 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,388 IT Pros & Developers. It's quick & easy.

Currency query help

P: 2
Hi!

I'm dealing with a vendor that needs me to format our import file a certain way to work with their system. Most of the issues are ok, but they need all currency values not as $79.95, but as 7995. $90 would have to be 9000. Their system has an implied decimal.

I'm trying to avoid having to manually edit the file since this is a regularly occurring task. Is there any way to make Access display currency this way? I figure I'm going to have to write a query, but I'm not sure where to start. I don't use Access very much any more and I never rose above the level of minimally competent.
May 31 '07 #1
Share this Question
Share on Google+
3 Replies

Rabbit
Expert Mod 10K+
P: 12,441
Hi!

I'm dealing with a vendor that needs me to format our import file a certain way to work with their system. Most of the issues are ok, but they need all currency values not as $79.95, but as 7995. $90 would have to be 9000. Their system has an implied decimal.

I'm trying to avoid having to manually edit the file since this is a regularly occurring task. Is there any way to make Access display currency this way? I figure I'm going to have to write a query, but I'm not sure where to start. I don't use Access very much any more and I never rose above the level of minimally competent.
Currency is only a display mask. I assume the file you're importing doesn't actually have the $ and decimals in it. It would most likely be stored as just a number. Just multiply the number by 100.
May 31 '07 #2

P: 2
Currency is only a display mask. I assume the file you're importing doesn't actually have the $ and decimals in it. It would most likely be stored as just a number. Just multiply the number by 100.
Wow. I was really making that a lot more complicated than it had to be.

It worked! Thanks!
May 31 '07 #3

Rabbit
Expert Mod 10K+
P: 12,441
Wow. I was really making that a lot more complicated than it had to be.

It worked! Thanks!
Not a problem. Good luck.
May 31 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.