Query criteria problem

[David B]

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

[John Winterbottom]

"David B" <Da***@marleycotenospam.fsnet.co.uk> wrote in message
news:c5**********@news6.svr.pol.co.uk...

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

Something like this:
SELECT eventDate, customerid
FROM SundrySaletbl
WHERE
(
eventDate=[Forms]![SundrySalefrm]![evdate] OR
[Forms]![SundrySalefrm]![evdate] Is Null
)
AND
(
customerid=[Forms]![sundrysalefrm]![selectcust] OR
[Forms]![SundrySalefrm]![evdate] Is Null
)