Dummy Records

[dkkirk2000]

Hello
I have a table with some old records that are not updated any longer but need to be included in a final report.
Is it possible to add that table to my query of new records??

Thanks!

 

[pbaldy]

A UNION query sounds appropriate:

SELECT Field1, Field2...
FROM OldTable
UNION ALL
SELECT Field1, Field2...
FROM NewTable

Search on union queries for the particulars.

 

[isladogs]

Assuming you don't want to append the old records to the new records table, you could run a union query and use that for your report

 

[isladogs]

Wow - I thought I'd replied quickly.
Paul's like Usain Bolt

 

[pbaldy]

Fastest fingers in the west!