Parameter query to use default data when none is entered 1

[MeldrethMan]

In a query that asks for a Start Date I'm trying to cater for people just hitting return when asked. If they do this I'd like the start date to be some default value. This SQL produces no results so suggestions what's wrong?

PARAMETERS [Enter Start Date] DateTime;
SELECT qryAllContacts.FirstName, qryAllContacts.Surname, qryAllContacts.[Record Created]
FROM qryAllContacts
WHERE (((qryAllContacts.[Record Created])=IIf(IsNull([Enter Start Date]),#1/1/1990#,[Enter Start Date])))
ORDER BY qryAllContacts.Surname;

 

[PHV]

What about this ?
WHERE (qryAllContacts.[Record Created]>=[Enter Start Date] OR [Enter Start Date] Is Null)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MeldrethMan]

Great, thanks, just what's needed