Correct field properties in a make table query

[quirkyjoe]

I am using ACCESS 2003 with a make table query. I use several make
table queries because the calculations I perform are slightly
different in each query depending on the underlying data the query
uses.

But when I use these several queries, the tables I generate need to
have all the same field properties.

Right now, after I make each table I manually go in to each and change
the field properties to what I want.

Is there any way to automate this, i.e., have ACCESS use the proper
field properties for each table I make using the make table query?

Thanks much.

 

[quirkyjoe]

I am using ACCESS 2003 with a make table query. I use several make
table queries because the calculations I perform are slightly
different in each query depending on the underlying data the query
uses.

But when I use these several queries, the tables I generate need to
have all the same field properties.

Right now, after I make each table I manually go in to each and change
the field properties to what I want.

Is there any way to automate this, i.e., have ACCESS use the proper
field properties for each table I make using the make table query?

Thanks much.

SORRY! WRONG GROUP! Please disregard!!!