Make Table query is changing data format

[kagoodwin13]

I am having trouble with a Make Table query truncating data, as well as changing the field formatting.



qryMAKE_TABLE has two fields: PART_NUMBER and MAX. In Design View of qryMAKE_TABLE, I changed the format of the field MAX to "General Number." In the field, there are decimals representing percentages (ie 0.1056 = 10.56%) , so keeping decimals is very important.

tblMADE_TABLE also has two fields as a result of qryMAKE_TABLE, PART_NUMBER and MAX. In Design View of tblMADE_TABLE, I changed the format of the field MAX to Number - Double.

After running qryMAKE_TABLE, it changes the MAX field to text in the qryMAKE_TABLE and in tblMADE_TABLE. This breaks a subsequent query that needs a number to run a conditional test (If MAX>1, flag as NO GOOD). However this conditional test can't run if MAX is text, it must be a number.

Any idea why Access refuses to keep field MAX as a number? Why is it converting to text while running a make table query? Any work-arounds?

[June7]

See reply in your other thread https://www.accessforums.net/queries...ord-40736.html