question about set location

[scooterny]

Folks,

I am using CR10 and in this case an Access DB. Each week I create a new table on Access, the same format as the previous weeks', only different data. I find myself recreating the CR query each week, as I am not able to point to an existing query and use a different table in the same Access DB. So I save the old CR query and rebuild. I suppose I could overlay last weeks' data, with some generic name. What do I do if I don't chose that option. Thanks for the help.

Scott

 

[synapsevampire]

Recreating the CR query means what in technical terms?

You use a Command Object or the table directly?

If you use a Command Object, add in a parameter and insert it wherever the table name is used witin the query.

Now it will ask you for the table name each time you run it.

If you intend to automate this task, I would create a query in Access which uses the latest table. or simpler, overwrite the old table, just put an exit macro in place to archive the latest table with the date.

-k