query problem

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have a database that stores descriptions of inspection
videos. The fields in my table are.

ID (autonumber and primary key), Tape # (text), Type of
Inspection (text), Company (text), Location (txt), Date
(txt), Report Included (yes/no), report # (txt), storage
box # (number), and Long Description (txt).

I want to make a query that uses type of inspection,
company, location, date, and long description as
parameters based on what the user enters. However, the
user may not have all of this information, and if they
just leave a certain field blank, the query only returns
records for which that field is blank. Any help would be
greatly appreciated!!
 
In your underlying query add the following 'OR' statement
to each parameter statement: OR "ENTERED PARAMETER" IS
NULL. Replace the words "ENTERED PARAMETER" with your
parameter name and enclose both the original parameter
statement and the 'OR' parameter statement in parentheses.
 
Back
Top