Access 97 Queries

[crv]

I am running a querie with a calculation, which will give me a currency format, how do I indicate in my querie to change the decimal spaces from 2 to 4?

 

[scriverb]

You can use something like this:

SELECT Format([tblYourTable]![MoneyDataField],"$#,##0.00&quot AS [MoneyField]
FROM tblYourTable;

This will format the field into whatever format you put in the statement. Here I have forced it to show 2 digits to the right of the decimal and one to the left and also included commas where appropriate and a dollar sign.

The table name and field name will have to be modified to reflect your situation.
Bob Scriver