Select Querie Question (1 Viewer)

[ecupirate]

How do I code a Date/Time field in a select statement to say:

IsNull or < #3/11/2002. I keep getting a criteria expression on the IsNull. I want to display the data if my table field is empty or is < the the above date..

Thanks in Advance...

 

[Adrianna]

Is Null Or <#03/11/2002#

This worked for me. If you are having trouble then try to place Is Null into one criteria spot and <03/11/2002 in the next criteria block below the Is Null statement. This should also work. I've tried it....worked for me in Access 97 and 2002.