How do I query the same field from different tables

[Mark]

I organize different system change requests by using separate tables for each
system type and give each change request a priority number. I have reports,
using sub-reports, showing all the priorities within each system (table). Is
there a way to create a query or report that lists the items by priority
number from different tables, while still maintaining separate tables for
each system? (For example I want all eight Priority #1's, then I want all
eight Priority #2 etc. to appear in one list)

 

[KARL DEWEY]

You need to combine the tables in to a single table. Copy the structue and
add a field for System identification.

Use append queries to put the data from all the tables in to the one. Add
another output field in the append query like --
System: "Your System Identification"
If the SYS ID field is a number the just put the number after the colon.

 

[Tom Ellison]

Dear Mark:

Look at the UNION query to combine information like this, probably the UNION
ALL variant. If this is a saved query in your system, you can then query
that query just as you would query a table.