Currency Symbols in Microsoft Access

Currency Symbols
By Richard Rost

6 months ago

Change Default Currency Upload Images Link
Jean-Pierre Christen
5 months ago

Hi Richard,

Is there a way to change the default currency in Access, WITHOUT making any changes to my region in control panel?

When I downloaded microsoft 365, the default currency is British Pounds ().

In my business we have 2 check registers:
USD- Our international clients pay our invoices in US Dollar.
Rs (Seychelles Ruppee) - This currency is for local office expenses.

On the table, design view, in format, I use this trick to change the currency:
For USD its $#,##0.00
For Rs its "Rs "#,##0.00

In your video, to calculate AMOUNT, you use a Query. In my access it shows as the default British Pound ()

Is there a way that the Query will also show it as the Currency format I choose? Seeing 2 different currencies when I run the query becomes very confusing and frustrating

Jean-Pierre Christen
5 months ago

Adam Schwanz
5 months ago

You can use Format(Field,Criteria)

Adam Schwanz
5 months ago

Using the index search on the site, it looks like Beginner 5 lesson 5: Format Query Field Output that might give you a video answer as well

Jean-Pierre Christen
5 months ago

Got it! Thanks Adam!

Have to refresh my knowledge and review the beginner courses again before I continue the expert series :)

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Currency Symbols