query 2 things at once

[agorman]

Hi,

I have a membership db with 120 members in it. Each record form includes a dropdown field for 'status' (training completed, no training, certificated etc), and another dropdown for 'profession' (childcare, nursing, education etc)

I am able to run 2 separate queries;
I can run a query to view all those who have completed training using
Like "*" & [Enter Status] & "*"

And I can also query the professions with Like "*" & [Enter Profession] & "*"

What I would like to do is to query members who are in education but have had no training yet. Is there any way I can do this?

Many thanks

Adrian

 

[Michael J Ross]

Add the status and profession fields to a query and use no training as criteria under Status and education as criteria under profession.

 

[agorman]

Thankyou for that - makes sense once you told me !

Much appriciated

Adrian