Blank Values

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

Guest

I have a query that lists records for the OHP carrier. Of the three records
below, I only want to see the record that has a date in the date field and
all the remaining fields are null. Out of the three records below, I want to
pull out the first record dated 3/5/2007.

Query Sample:

ID Carrier Name Date EKG Lab
CBC

1 OHP 3/5/2007 Covered Covered
1 OHP 7/1/2007
1 OHP 10/1/2007

Can this be done? If you need more information, please let me know.

JS
 
Use criteria of
IS Null
if you want to get records where the value is null

Use criteria of
Is Not Null
if you want to get records where the field has a value

Field: Date
Criteria: Is Not Null

Field: EKG
Criteria: Is Null

Field: Lab
Criteria: Is Null

That shoud return records where the date has a value and EKG and Lab are
blank. If you want records where all three fields have a value then change
IS Null to Is Not Null

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top