select query to show all records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try:
Where RigDesignation = [Enter Rig Designation] or IsNull([Enter Rig
Designation]);
 
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...
 
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]
 
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...
 
Back
Top