Multiple Table/duplicate record query

[RonnieDobbs]

I have several tables that deal statuses of assignments. A form for each of these tables allow users to enter statuses off assignments. I would like to run a query to browse through these tables and pull information.

Example: An assignment, with its own unique ID, could have been on hold, and then a month later been reactivated. This info would have been entered into two different tables (hold and reactivate), how would I pull info if I wanted to see pending hold to pending reactivates for the say a London office?

Any suggestions??

AB

 

[M8KWR]

You would need some code like this

SELECT reactivate.UniqueID, reactivate.Assignment
FROM Hold INNER JOIN reactivate ON Hold.UniqueID = reactivate.UniqueID;

But you could do other things with this, like put a date range into it etc

Hope this helps

 

[RonnieDobbs]

Can this code allow assignments to be pulled from all pending tables. For instance, There are 6 pending tables. How would I add multiple tables? Where could I find more information on the date parameter option?

thanks for the input!
AB