quires

[Michael]

I am trying to make a parameter quirey with selection
criteria. I have about four design grids that call for
input from the user.

In the criteria I have typed: Like [Enter CSC:]
In the or cell I have typed: [Enter CSC:] Is Null

in a new design grid I have

In the criteria I have typed Like: [Enter Employee Type:]
In the or cell I typed: [Enter Employee Type:] Is Null

and so on with the other grids.

The result is fine if I entered criteria in the input box
for all the different grids. It also works fine if I
leave all the input boxes blank for the null side.

The problem is if I put criteria in any input box and any
other input box I leave blank, then it returns no records.

Any help would be appreciated. Thanks

Michael Abercrombie

 

[John Spencer (MVP)]

You need to put both criteria in ONE CELL.

Criteria: Like [Enter CSC:] OR [Enter CSC:] Is Null

Do this for your four fields. When you save and reopen, you will find that
Access has restructured your query into something quite a bit more complex. It
may or may not work - Query too complex error.

If it doesn't work and one or more of your fields never contains a null value,
there are other ways to handle this situation.

I am trying to make a parameter quirey with selection
criteria. I have about four design grids that call for
input from the user.

In the criteria I have typed: Like [Enter CSC:]
In the or cell I have typed: [Enter CSC:] Is Null

in a new design grid I have

In the criteria I have typed Like: [Enter Employee Type:]
In the or cell I typed: [Enter Employee Type:] Is Null

and so on with the other grids.

The result is fine if I entered criteria in the input box
for all the different grids. It also works fine if I
leave all the input boxes blank for the null side.

The problem is if I put criteria in any input box and any
other input box I leave blank, then it returns no records.

Any help would be appreciated. Thanks

Michael Abercrombie