select query to show all records

L

LisaVH

I have a pretty basic select query. The user types in the "Rig Designation"
and a list of all projects utilizing that rig are displayed in date order. I
would like to include an option that will display all projects regardless of
rig or all records with no rig (null value). I have searched other posts and
either can't find the answer I need or don't understand the answer given.
Can anyone please help a newbie?

Lisa.
 
P

Pat Hartman\(MVP\)

Try:
Where RigDesignation = [Enter Rig Designation] or IsNull([Enter Rig
Designation]);
 
L

LisaVH

Sorry for my ignorance, but do I type that on the criteria line of the query?

Pat Hartman(MVP) said:
Try:
Where RigDesignation = [Enter Rig Designation] or IsNull([Enter Rig
Designation]);

LisaVH said:
I have a pretty basic select query. The user types in the "Rig
Designation"
and a list of all projects utilizing that rig are displayed in date order.
I
would like to include an option that will display all projects regardless
of
rig or all records with no rig (null value). I have searched other posts
and
either can't find the answer I need or don't understand the answer given.
Can anyone please help a newbie?

Lisa.
Click to expand...
Click to expand...
 
J

John Vinson

I have a pretty basic select query. The user types in the "Rig Designation"
and a list of all projects utilizing that rig are displayed in date order. I
would like to include an option that will display all projects regardless of
rig or all records with no rig (null value). I have searched other posts and
either can't find the answer I need or don't understand the answer given.
Can anyone please help a newbie?

Lisa.
Click to expand...

Use a criterion of

[Enter rig designation:] OR [Enter rig designation:] IS NULL

John W. Vinson[MVP]
 
L

LisaVH

Thank you both very much. This problem has been making me crazy. That
worked perfectly.

Lisa.

John Vinson said:
I have a pretty basic select query. The user types in the "Rig Designation"
and a list of all projects utilizing that rig are displayed in date order. I
would like to include an option that will display all projects regardless of
rig or all records with no rig (null value). I have searched other posts and
either can't find the answer I need or don't understand the answer given.
Can anyone please help a newbie?

Lisa.
Click to expand...

Use a criterion of

[Enter rig designation:] OR [Enter rig designation:] IS NULL

John W. Vinson[MVP]
Click to expand...
 
Top