Make Table Query is converting currency field to a number in the t

[Guest]

I have a make table query that is performing many cost currency calculations.
When you run the query as a SELECT query all of the calculations come out as
currency ex: $1.24. This is how I want it to come out. When I run it as a
make table query it converts the currency to a number in the table and I am
getting 1.2456 instead of the $1.24 that I was getting in the query. I am not
sure if this helps but the currency fields in the query are EXPRESSIONS that
I created. For the life of me I do not know why.

 

[OfficeDev18 via AccessMonster.com]

Try this: right click on each currency field in the query design grid, and in
the dialog box, type the word Currency in the Format space.

HTH

 

[Guest]

Mr OfficeDev18-
I tried this and it did not work. Any other suggestions.
Thank you for your quick response.

 

[Steve Schapel]

Curt,

You could try using the CCur() function in the query.

If you still need help with this, it will be a lot easier for potential
helpers if you could give some specific detail, examples, and the SQL
view of the make-table query.

 

[OfficeDev18 via AccessMonster.com]

Alternatively, you can run the Make Table query manually once. Then go in and
change the fields you want as currency to data type 'currency' (they will
probably be type 'number' with field size 'decimal' or 'single'). For the
future, instead of re-making the table, simply delete the table contents
(with a delete query) and change your Make Table query permanently to an
Append query.

There's more than one way to skin Access' cat.

HTH

Curt,

You could try using the CCur() function in the query.

If you still need help with this, it will be a lot easier for potential
helpers if you could give some specific detail, examples, and the SQL
view of the make-table query.

I have a make table query that is performing many cost currency calculations.
When you run the query as a SELECT query all of the calculations come out as

[quoted text clipped - 3 lines]

sure if this helps but the currency fields in the query are EXPRESSIONS that
I created. For the life of me I do not know why.