I am really having a bad run on the DB this weekend, my latest scenario is as follows:
Query#1 creates a table and calculates amounts with to 10 decimals, this is what I need as the amounts represent thousands of dollars and I want to be able to include decimals in further calculations.
Query #2 is an UPDATE query(not append as I said in the title) and it takes the results of the table created by Query#1 and updates to another table. Problem is.. Query #2 is removing all of my decimals. Its enough to make me cry, as things don't balance without the decimals. Can somebody pleeeeease tell me how to stop the update query from rounding out all my decimals, its driving me nuts.
Many thanks
[This message has been edited by Becca (edited 03-03-2002).]
Query#1 creates a table and calculates amounts with to 10 decimals, this is what I need as the amounts represent thousands of dollars and I want to be able to include decimals in further calculations.
Query #2 is an UPDATE query(not append as I said in the title) and it takes the results of the table created by Query#1 and updates to another table. Problem is.. Query #2 is removing all of my decimals. Its enough to make me cry, as things don't balance without the decimals. Can somebody pleeeeease tell me how to stop the update query from rounding out all my decimals, its driving me nuts.
Many thanks
[This message has been edited by Becca (edited 03-03-2002).]
