ow do I run a multi-table query?

[Guest]

I have a database set up which includes 8 tables. I need to do a query which
searches 4 of those tables for null values. Basically, the tables I've
produced show items in two stages. Four show items in separate depts in
their first stage and the other four tell which items from the first stage
have moved to the second stage. I need a query that will search each of them
and tell us which items for each dept have NOT moved to stage two. Any
chance anyone can assist???

 

[Jeff Boyce]

Candace

From your description, it sounds like you'd have to duplicate information
between your two sets of tables, and that your data is in identical tables,
each department having it's own table.

If this is the case, your design needs further normalization. I may not be
understanding your underlying data, but it sounds a bit like you could do
everything in fewer tables ... like:

tblItemStage
ItemStageID
ItemID (foreign key from an "Item" table)
DepartmentID (foreign key from a "Department" table
StageID (foreign key from a "Stage" table)
StageDate

To see what stage some item is in, do a query that finds the Max(StageDate)
for that Item.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

The tables are identical. The only problem is that I'm doing the queries
through the query tab, not writing the code myself...I'm not quite that
advanced. I did relationships between the tables and was trying to run the
query based on that but I keep getting errors.

 

[Jeff Boyce]

Please re-read my response. If the tables are identical, you have a ...
spreadsheet, not a relational database!

Regards

Jeff Boyce
Microsoft Office/Access MVP