NZ Function in query

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I want to filter records that have an "End Date" after a specified date
"DATE" (this is entered during the query). Easy enough..... Although in
many records the "End Date" field is not entered. I have been working with
the code:

WHERE (((nz([EndDate],#12/31/9999#))>=[Date]))

This does not work at all. I think it might have something to do with the
"DATE" that is entered during execution. I think that the date I enter is
just text and not a real date. If this is correct how can I format the
"DATE" entry? If I am wrong, .....help please
 
add the following line to the beginning of your SQL statement, before
"SELECT...", as

PARAMETERS [Date] DateTime;

hth
 
Works great...Thank you!


tina said:
add the following line to the beginning of your SQL statement, before
"SELECT...", as

PARAMETERS [Date] DateTime;

hth


Jeff said:
I want to filter records that have an "End Date" after a specified date
"DATE" (this is entered during the query). Easy enough..... Although in
many records the "End Date" field is not entered. I have been working with
the code:

WHERE (((nz([EndDate],#12/31/9999#))>=[Date]))

This does not work at all. I think it might have something to do with the
"DATE" that is entered during execution. I think that the date I enter is
just text and not a real date. If this is correct how can I format the
"DATE" entry? If I am wrong, .....help please
Click to expand...
Click to expand...
 
Back
Top