Parameter Query

[drewdt3]

I have a query with 2 parameters, Date and a yes/no. Is it possible to use the IS NUll function on only one and return within the parameters of the other. At the moment if I use the Is Null function on either one I get every record in the table.

Help!!!

 

[andersonjond]

Is it possible to use the IS NUll function on only one and return within the parameters of the other. !!!

You have to use the following syntax in the QBE grid.

forms![FormName]![ControlName] or Like forms![FormName]![ControlName] is null

Where
FormName is the name of your form
ControlName is the name of your control on that form

Then once you run the query, save it, close it, and open it again you will see that Access changed the grid. It constructs the various permutations you need to capture all cases.

In a database, NULL means "UNKNOWN" and so it returns NO records. At first it's a bit counter-intuitive, but after a while you get the hang of it.

 

[drewdt3]

Is it possible to use the IS NUll function on only one and return within the paramete

Sorry, I don't understand your string, I don't want to use a form I want to do this in a parameter query but if I leave one or the other queries blank i get all records instead of partially filtered which is what i want.

 

[ColinEssex]

a yes/no field does not have Null values - they are either -1 or 0

Col