Query with multiple options

C

catherine

I have two tables: tblTraining and tblInfo.

In tblTraining, I have historical data (i.e trainings that
have already been taken) and in tblInfo, I have current
data of what training is needed. For example:

In tblTraining, I have TeacherNo and Training
5 Weather

In tblInfo, I have TeacherNo and 1, 2, and/or 3 Trainings
5 Weather, Organisms, Chem

What I would like to do is query this info so that it
would show TeacherNo: 5 needs Organisms and Chem (not
Weather since that has been done). Is this possible?
Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Index into a Table 1
Filter Fields Containing Values Found in Another Table 4
Joining two queries 2
Crosstab Query on tables with Many to Many relationship 7
Find duplicates in two tables, report one of them, and keep unique entries 0
Filter records not meeting criteria 2
Complex query to return training completion dates 2
Taking the sum between two dates 2

Top