How to set a format of a field in a Make Table Query

[dfaulkner1]

Hi

I have numerous databases that I use with make tables in there, these will often contain Currency values that we need to be set as just General Numbers. We can get it to work in the Query but whenever we run the query, the table it makes always shows up as currency.

Is there a way so that the table created will automatically be just General numbers

I hope this makes sense

Thanks


Dan

[ranman256]

instead of MAKE table query, just predefine the table and all formats, then use APPEND query. this way all formats are preserved.

but you could try, in the make table,
right click on the field in the query,
set property format

[June7]

Why making tables? This is a design modification to db. Usually a bad idea and a sign of non-normalized data structure.