query expression to capture entries with no data

[dumdum2]

I have a query with the following expression in the criteria row under the 'pitch result' field.

IIf(IsNull([forms]![reportdates]![combo22]),[pitch result],[forms]![reportdates]![combo22])

This expression pulls only records that have data in the [pitch result] field, and I'd like to pull all records including the blank field records.

How would I do that?

Thanks!

 

[PHV]

You may try this:
=[Forms]![reportdates]![combo22] OR [Forms]![reportdates]![combo22] Is Null


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dumdum2]

thanks, that worked!