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

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.

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

Curt Johnson wrote:
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.

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200601/1

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

"OfficeDev18 via AccessMonster.com" wrote:

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

Curt Johnson wrote:
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.

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200601/1

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.

--
Steve Schapel, Microsoft Access MVP


Curt Johnson wrote:
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.

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

Steve Schapel wrote:
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.

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200601/1