Crieria based on form

[jamphan]

I have a query that has the criteria based on what is entered in a form. My syntax is >[Forms]![Index]![NoticeDate]. What I would like to happen is if data is entered in the form field the results that are greater than that date will be returned but if nothing is entered all values will be returned. I am having trouble with the last part. Right now if nothing is entered I don't receive any information. thanks for the help.

 

[RV]

Add this field:

Forms]![Index]![NoticeDate]

using this criterium on the field:

Is Null

RV

 

[jamphan]

Are you saying add this new field as a new query field and put the Is Null in the criteria? Not really sure I am following you.

 

[jamphan]

Diregard the last thread. I got it to work. Thanks.