IsNull problem in query

[excelhk]

I can’t design my query to work. I think it’s because MeetingLocation is an optional field in my table and the query doesn’t show the empty Meeting Location values. I want to design a query that needs to show the IsNull MeetingLocation values in between dates. How do I get IsNull values to show up in the dates that I want?



See below:



Table Fields:
MeetingLocation (optional), MeetingDate(mandatory), PersonID (mandatory)

Search Form:
-MeetingLocation
-From Date
-To Date
-PersonID


------


The user enters some values in the search form...

Logic of my query:
- If meeting location and dates are blank then show all values in table.
- If only From Date and To Date have search form values then show all records in table between From Date and To Date.


- If only Meeting Location has search form value then show all records in table in that Meeting Location.
- If all the search form has values then show all records in that table in Meeting Location between From Date and To Date.

[June7]

Options:

1. set a DefaultValue for the field in table (or control on form) like "None" so that the field is never null

2. construct a field in query that handles the null and apply filter to that constructed field

Nz([MeetingLocation],"none")

3. Use Or Is Null in the parameter for that field

[excelhk]

Thanks for the tips!