Identifying no records for a client

[Softweb]

Hi. I would be grateful for any help with the following query design.
I have a table of registered Clients (tblClient) who require training, and this table is linked by Job_No to a table (tblTraining) that holds training session data for Clients. A Client firsts registers, and their information is entered in tblClient. At some point later in time the Client is allocated a training session which is entered in tblTraining. I need a query that will pull out all registered Clients that have NOT been allocated a training session. I thought it would be easy but perhaps my brain is not in gear today. Thanks

 

[Gasman]

Why not use the query wizard for Unmatched records?

 

[ypma]

Another thought . A query based on the tblclient and tbltraining with a criteria in the training session field is Null . If I have understood your question only records which have not been allocated a training session would be shown in the query .

Regards Ypma

 

[Softweb]

Many thanks Gasman and ypma. The solution you suggest works fine. Thanks again