Query to check data in old and new tables

[aman]

Hi Guys,

I have created a new table which has replaced the old tables due to business needs. Now my report is not pulling through the historical data as it's pointing to the new table. How can I change my query so it will check reference number in old table and if it's there then pull through the data and if it's not then check in new table.

Can we do something similar?

Thanks

 

[theDBguy]

Hi. Just a guess but try changing your query into a UNION query.

 

[pbaldy]

Short version, you can't. You can create a UNION query that joins the two tables together, or modify the report's record source dynamically.

 

[Anakardian]

Any reason you don't want to move the old data into the new table?
that would solve the issue a lot simpler