number field

[JIM.H.]

Hello,
I use a make table query and I need to add an extra
number field into result table to update it later. I user
myNumber:0.00 in the query but number becomes 0 and when
I use update query it does not bring show decimal points.
How should I create that extra field to keep two decimal?
Thanks,
Jim.

 

[Jeff Boyce]

Jim

You don't have as much control over the number type (Integer, Single, ...)
if you use Make Table queries. Have you considered creating the table
structure, data typed as you need, and using Append queries? You could
"clear out" the table with a Delete query before running the Append...