Parameter query with null entry...

  • Thread starter Thread starter MarkV
  • Start date Start date
M

MarkV

I have a query which selects items which are due for
inspection. I used a parameter query to enter the number
of days in the future to show if the record will be do
soon. I would like the query to just show all records if
the operator enters nothing in the parameter entry box
(either by choice to see all values, or forgets to enter
value).

The query below fails with the message:
"This expression is tryped incorrectly, or it is too
complex to be evaluated...."
I don't see a typo, is there another way to structure the
query?

Thanks MarkV

SELECT qryLatestItemInspectionDetail.*
FROM qryLatestItemInspectionDetail
WHERE (((qryLatestItemInspectionDetail.NextDueDate)<DateAdd
("d",[DaysAhead],Now()))) OR (([DaysAhead] Is Null));
 
Back
Top