Can you use code to make a table?

[poctok]

I currently have a make table query doing this job and it works fine. But now I want to pass a variable (lastupdate stored in a table) to the query and can't see how to do it?

Can I replace the query with VBA? and that way pass it the variable?

Any and all help would be appreciated.
Thanks
Nicky

 

[TTThio]

Hi Nicky,

yes, you can use VBA to do 'Make Table Query'.
Use "SELECT fields INTO new table FROM source WHERE criteria".

Take a look at your built-in make-table query, go to VIEW - SQL. That's how you create a SQL statement in module. You just have to add the WHERE criteria if you want to make table from the last updated records only.

Good luck!
Tin Tin

 

[poctok]

Cheers Tin Tin.
Spot on!
Nicky