Forum home » Delegate support and help forum » Microsoft Access Training and help » Currency formatting

Currency formatting

ResolvedVersion 2007

Tue 9 Nov 2010, 15:50 Delegate James said...

James has attended:
Access Intermediate course

Currency formatting

How do I show data formatted as a foreign currency in queries and reports? E.g. USD

Tue 16 Nov 2010, 11:09 Trainer Simon said...

RE: Currency formatting

Hi James,

Thank you for your question and welcome to the forum.

The first thing you need to do to change the Regional Settings and change it to US settings.

http://www.utteraccess.com/forum/change-dollar-sign-tab-t540016.html

The forum above talks about how to change the format of a field in a query and then you could produce the report based on that query.

I hope this answers your question.

Regards

Simon

Tue 16 Nov 2010, 15:56 Trainer Richard said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Tue 23 Nov 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

Currency formatting

Currency formatting

RE: Currency formatting

Will be marked as resolved in 5 days

Access articles

Access tip:

Hide Access Tables