Correct field properties in a make table query

  • Thread starter Thread starter quirkyjoe
  • Start date Start date
Q

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.
 
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.
Click to expand...

SORRY! WRONG GROUP! Please disregard!!!
 
Back
Top