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.
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.