A
Adam
Hi,
I have a query which looks at a form and searches between a range of
dates.
The expression I've been given to put into my query is as follows:
WHERE ([ContactDate] >= CDate([Forms]![Open Contact frm]![StartDate])
OR [Forms]![Open Contact frm]![StartDate] IS NULL)
And
([ContactDate] < DateAdd("d", 1, CDate([Forms]![Open Contact
frm]![EndDate]) OR [Forms]![Open Contact frm]![EndDate] IS NULL)
This is giving me the error message "The expression you have entered is
missing a closing parenthesis bracket (]), or vertical bar(|)."
Does anyone know whats wrong with this expression?
I'm using Access 97.
Adam
I have a query which looks at a form and searches between a range of
dates.
The expression I've been given to put into my query is as follows:
WHERE ([ContactDate] >= CDate([Forms]![Open Contact frm]![StartDate])
OR [Forms]![Open Contact frm]![StartDate] IS NULL)
And
([ContactDate] < DateAdd("d", 1, CDate([Forms]![Open Contact
frm]![EndDate]) OR [Forms]![Open Contact frm]![EndDate] IS NULL)
This is giving me the error message "The expression you have entered is
missing a closing parenthesis bracket (]), or vertical bar(|)."
Does anyone know whats wrong with this expression?
I'm using Access 97.
Adam