blanks in one or all of the fields

  • Thread starter Thread starter HelpMe!
  • Start date Start date
H

HelpMe!

I have a table with the following fields:

SupervisorLast
SupervisorFirst
EmployeeLast
EmployeeFirst
Probe1PeriodStart
Probe1PeriodEnd
Probe1CompletionDate
Probe2PeriodStart
Probe2PeriodEnd
Probe2CompletionDate
Probe3PeriodStart
Probe3PeriodEnd
Probe3CompletionDate

I want to run a query that will show me only the records that have blanks in
one or all of the “Completion Date†fields. I have no idea where to begin.
Any suggestions?
 
Open your query
Add all the fields
== under Probe1CompletionDate enter the following in the FIRST criteria row
Is Null
== Under Probe2CompletionDate enter the following in the SECOND criteria row
Is Null
== Under Probe3CompletionDate enter the following in the THIRD criteria row
Is Null

A better table design would make this simpler.
Your current table would have something like the following:
PKID (autonnumber field)
SupervisorLast
SupervisorFirst
EmployeeLast
EmployeeFirst

THen you would have a second table
ProbeDates
FirstTableIDRecord (Long number field containing a reference to the first table)
PeriodStart
PeriodEnd
DateComplete

YOu would have one record in this table for each Probe event (?).

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top