Purged Reports

[newbie123 via AccessMonster.com]

Hi!

I have two tables in the dbase.

Table 1 - List of new records queued to be worked by the employees. Fields in
this table are:
*Queue_Name - the queue in which the record came from.
*Date - Date the record queued
*Record
*DateTime - Date & Time the record queued

Table 2 - List of "new records" (from table 1) that were purged, meaning the
record was not worked within the 3 days since it queued. Fields in this table
are the same as table 1.

I would like to create a query that will give me the records that purged from
table 1 and now in table 2...and if the same record showed up in table 1 at a
later date.

Thoughts?

Thanks!

 

[KARL DEWEY]

You need to change your field names from Date and DateTime to something else
like [queueDate] that is not a reserved word.

What field do you use to uniquely identify a record?
SELECT [Table2].*
FROM Table2
UNION ALL SELECT [Table1].*
FROM Table1 INNER JOIN Table2 ON [Table1].[uniquely identify] =
[Table2].[uniquely identify]
WHERE [Table1].[queueDate] <> [Table2].[queueDate];