Currency Formats in an append query

[DanMurphy]

Hello

My office has a database that manages a small number of direct debit collections. Our Direct Debit software connects to a table to collect information, that table is filled by data from a query.

Unfortunately, we need to prefix some currency figures, however the premium amount appears incorrectly once we do.

In the tables the figures are originally stored, one thousand euros appears correctly as 1.000,00 (Spainish Setting).

However, we require a prefix on the figures, and when that is added the figures switch to English settings.

So what should appear as "I.P.S.: 1.000,00" is appearing as "I.P.S.: 1,000.00"

For any figures that do no require the prefix, the premium amounts appear correctly.

Attached is a screenshot of what I believe are the offending pieces in the query.

This is not my database, so I am not fully sure how it works, however the person who can fix this is too busy being deafened by vuvuzelas.

If anyone could point me in the right direction to fix this it would be appreciated.

Thanks in advance.

 

[vbaInet]

Have a look at the Format() function:

http://www.techonthenet.com/access/functions/numeric/format.php