Run Make Table query automatically

[tuna]

Hi, is it possible to run a Make Table query automatically on opening another query (who takes values from the table created by the Make Table query)?

Thanks

 

[ajetrumpet]

yes it is.....lol

 

[Brianwarnock]

yes it is.....lol

What is the point of that Adam? Did it make you feel good, superior maybe?

Tuna the simplest way to do this is to create a macro that runs the make table query then the second query, but the experts will tell you to use VBA to do this as it allows for error checking.

Brian

 

[ajetrumpet]

What is the point of that Adam? Did it make you feel good, superior maybe?

Tuna the simplest way to do this is to create a macro that runs the make table query then the second query, but the experts will tell you to use VBA to do this as it allows for error checking.

Brian

Brian,

there is no point to it, other than maybe seeing if this person will realize that being a little more specific is what you should do!

And thanks for the advertisement too.