nicht angemeldet
Access 2002
How do I get a query to show currency value for USA instead of German. Eg I want 10.00 not 10,00 without changing the Land settings on OS. This runs on a Deutsch M$ OS. MySQL allows FORMAT(column, '##.##') or something similar, M$ doe not HELP!
-
Moin!
How do I get a query to show currency value for USA instead of German.
One way:
If you use Access 2002 you can use VBA to transform the values. VBA meens "Visual Basic for Applications", i'ts inside your M$ office.MFFG (Mit freundlich- friedfertigem Grinsen)
fastix®
--
Als Freiberufler bin ich immer auf der Suche nach Aufträgen: Schulungen, Development. Auch für seriöse Agenturen. -
Moin!
How do I get a query to show currency value for USA instead of German. Eg I want 10.00 not 10,00 without changing the Land settings on OS. This runs on a Deutsch M$ OS. MySQL allows FORMAT(column, '##.##') or something similar, M$ doe not HELP!
I begin to wonder why you are asking this question in english in this german forum?
I can only repeat myself: Consult that fucking manual for MS Access. You should have installed a help file somewhere - read it -, or either try one or more search engines. Don't forget to check the Microsoft Knowledge Base.
- Sven Rautenberg
--
ss:) zu:) ls:[ fo:} de:] va:) ch:] sh:) n4:# rl:| br:< js:| ie:( fl:( mo:|