Number format changes on it's own

[bravo6]

I have a make table query in which one of the fields is formated as currency. It works fine. I also have several append table quries which append to the table. No matter what I do, the number in the currency field reverts to an integer. I have made sure that all of the fields in all the queries are formated correctly and that the table is also formated correctly. The results come out with a decimal and two zeros to the right (eg 787.00) instead of the correct amount of (eg 787.35)

 

[PHV]

Are you sure the append queries doesn't coerce the decimal values to integer ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[maxhugen]

In the table you create with the make table query, is the Data Type showing as Currency?

In your Append queries, if you View the query (as opposed to running the Append), are the currency values correct?

Max Hugen
Australia

 

[PoppaSmurf]

I would do the following as a safeguard. Create a table with the fields and correct format etc.

Run a query to delete the existing data in the above table. Then run an append query to add the new data to the above table.

PoppaSmurf