Difference queries

[Guest]

How do I do a query in Access to tell me the difference between two tables?
I have a table that lists all departments, and a table that has weekly
department data, and I want to be able to query the database to see who has
NOT submitted their data...

 

[Guest]

hi,
access has a wizard for that.
on the database window, click the query tab then click new
when the new query box comes up, i think you want the find
unmatched query wizard.

 

[Guest]

That works except for the weekly data format I am using. That query wizard
will let me know if the department has EVER submitted a report, but not by
week...

 

[Guest]

Do your query as you would see everything for that week, using LEFT OUTER
JOIN and verify if the child table (DEPT_DATA) is null

select *
from Department
left outer join Dept_Data on (Dept_Data.DeptID = Department.ID)
where Dept_Data.Week = [Week number?]
and Dept_Data.DeptID is null

I didn't test but it should work

Mauricio Silva