Query with criteria

  • Thread starter Thread starter Mani
  • Start date Start date
M

Mani

Hi! Please bear with me as I am not an expert on Access, so I appologize for
my lack of access language. So, I have a query, and on one particular field
I want it to pull certain information using the IsNull expression, but
somehow it's not working. Let me backup and give more detailed information.
The field name is called Service Category, and the Service Category in the
form is a combo box with these items: Campus Visit, College Readiness,
Admissions Application, Financial Aid Application, Tutoring, Program
Activities, and Academic Counseling. On this Query that I have, I just want
the field to pull up students that don't have Admissions Application and
Financial Aid Application. I don't want all items to pull up. Does that
make sense?? Please HELP!!!!!
 
Not like "admission" and not like "financial aid"
If you use and it has to find them both or return nothing. If you use OR it
will return either or one.
 
Back
Top