Make Table Query Help

[efinnen]

I always have problems explaining my issues. But anyways, here goes...

I have a make table query that takes a table that the user imports and collapses (totals : group by) on an ID, There are three fields that also gets added in on the query and calculated out to zero. (i.e. Thickness : 0, etc.).

The user will change these fields on the next form.

My issue is that these fields that the user changes require decimals, and when I make the fields, It doesn't hold the decimal place. I can manually change these in the table, but that doesn't help when its not me running it. I've also tried changing the field properties in the query, to no avail....

My work around right now is that I give each ID the same exact default values and let the user change these on the following form (thickness : 0.322 instead of 0), but truthfully I don't like my workaround..

Anyone know how to programitcally change the format on a table??

Any help and/or suggestions would be appreciated.

Thanks
-Eric

 

[PaulF]

why use a Make Table query, why not use a Delete and Append queries, that way the table structure never has to change.

PaulF

 

[efinnen]

Thanks, That definetly was a much better workaround. I appreciate it.

-e