I have a query which gets its criteria from a form. On the form is a combo
which selects cust number and a text box selecting date.
This works fine if both have data or both are null.
Is there a way to have 1 with data and 1 null. -- So I can see all the
customers with activity on 11th March or I can see all of Mr White`s activity on
any day
SQL follows
SELECT SundrySaletbl.eventDate, SundrySaletbl.customerid,
[Forms]![SundrySalefrm]![evdate] AS Expr1, [Forms]![sundrysalefrm]![selectcust]
AS Expr2
FROM SundrySaletbl
WHERE (((SundrySaletbl.eventDate)=[Forms]![SundrySalefrm]![evdate]) AND
((SundrySaletbl.customerid)=[Forms]![sundrysalefrm]![selectcust])) OR
((([Forms]![SundrySalefrm]![evdate]) Is Null) AND
(([Forms]![sundrysalefrm]![selectcust]) Is Null));
TIA
David B
Hexham UK