Originally posted by Wulf13
My DB tracks courses taken by people. Most of these have an expiration date. I can make a query to show me who is overdue on class "x", "y" and I can make a query to show me who hasn't taken "x", "y".
Is there a way I can combine the two queries into one report?
In your db, the CourseReportCurrent query returns 6 records and the CourseReportOverdue query returns 2.
If what you want is combine them in one query showing 8 records, you can join them in a Union Query as Paul suggested in his first post.
Select [name], "Current" as [Type], [studentNum], [organization], [section], [className], [classDateTaken], [scores], "" as [lengthValid], [Date Expires]
from [CourseReportCurrent]
UNION
Select [name], "Overdue", [studentNum], [organization], [section], [className],
[classDateTaken], Null as [Scores], [lengthValid], [Date Expires]
from [CourseReportOverdue];
^