Q
Question Boy
I have the following WHERE clause in my query
WHERE (((Nz(Year([Delivery Date]),"*"))=[For which year]))
However when the user does not enter a value at the prompt, I get no records
returned and I want all the records returned (regardless of the Delivery
Date). What is wrong with my SQL statement?
Thank you,
QB
WHERE (((Nz(Year([Delivery Date]),"*"))=[For which year]))
However when the user does not enter a value at the prompt, I get no records
returned and I want all the records returned (regardless of the Delivery
Date). What is wrong with my SQL statement?
Thank you,
QB