make table query with an index field?

[MarcelMegens]

I use quite a few make table queries, the only problem that I have is how to automatically create an index field(other than generating it manually through table design)

I have no problems working with access macro's but I'm a "no-go" as far VBA is concerned (unless I can copy a piece of VBA into a procedure and change some variables)

Regards,

Marcel

 

[FoFa]

You can create and index via VBA, but if it is a table you use a lot, why not use append instead of make table, and just set the indexes.