Find & Replace Table source data?

[Red Kenny]

Hello,

A question please.

I have a query referencing a source table, but I would like to copy my query to keep all the layout and format but change the source table to an identical table, but with a different name and data. Is this possible?

To go into more detail I want to keep the entire query design for my sales table but change the source data to the previous year's sales table.

Thank you.

[ranman256]

It doesn't make sense to change the source.
if I say my source is table1, why would the code change it to table2, when I want 1?

[Red Kenny]

It doesn't make sense to change the source.
if I say my source is table1, why would the code change it to table2, when I want 1?

To keep the exact same format of the query, column for column, rule for rule to table 2. I.e. to save the hassle of design the same query 5 times.

[Gicu]

Why have a sales table for each year? Why not put them together in one single table and add a Year field (or simply use Year(SalesDate) in your query to limit the year to the year part of the date of sale). Any way, if you want to replace the source table the easiest I found is to copy the SQL statement of your query to Word or Notepad and in there do a Replace All for Table1 with Table2. You could also do it in VBA by editing the SQL property of the querydef.

Cheers,
Vlad