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.

Specifically which properties are you adjusting? It may be easier for you to
create a table shell and then make copies of that blank table and have your
queries be append queries instead of make table queries. Nevertheless, if you
tell me which properties you are changing, I may be able to write some VBA
code for you to change it.

"quirkyjoe" wrote:

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