iif IN QUERY CRITERIA

[Soulac]

I have would i initially thought was a simple issue I am querying a table with a field called Appt Slot and all it contains is AM or PM .in my query criteria i initially thought to put [enter slot 'AM' Or 'PM' or leave blank for All]
AM AND PM Work fine but just clicking ok on the parameter box Returns Nothing at all so I tried IIf(IsNull([slot])=True,"AM" Or "PM",[slot]) this it seems is too complicated for access to solve. Yet IIf(IsNull([slot])=True,"AM",[slot]) Works Fine. I have Also Tried IIf(IsNull([slot])=True,Like "*M",[slot]) and a lot of other version and differing syntax but to No Avail

Can Anyone Help

 

[giacomo]

Check out "Showing All Records (Including Null) in a Parameter Query" from the MS Knowledge Base:

http://support.microsoft.com/default.aspx?scid=kb;en-us;103181

 

[khexcel]

Try this:
in the Appt Slot field type this in the criteria section of the query:
[enter slot 'AM' Or 'PM' or leave blank for All]

in the OR section (below the criteria section) type this:

[enter slot 'AM' Or 'PM' or leave blank for All] is null

This will return all fields if null or return AM or PM values when specified.
Regards,