Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

question about set location

Status
Not open for further replies.

scooterny

Programmer
Jan 19, 2007
26
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top