Parameter query ignores blank records 1

[mdlaugh1]

I have the following prompt in a criteria field:

Like [Enter the TYPE OF WORK or * for all] & "*"

As long as a record has a value in "type_of_work" the record is selected. but it ignores rows with blank (null?) in that field.

I have created a new field called TYPE_WORK with the following calc: TYPE_WORK: IIf(IsNull([TYPE_OF_WORK]),'NOT ENTERED',[TYPE_OF_WORK])

which forces the value "Not Entered" into the empty fields, and then query pulls all records, but this is a long way around....

Is there a way to simply select the record showing the field to be blank, without forcing the 2nd calculated field? thanks!

 

[PHV]

Like [Enter the TYPE OF WORK or * for all] & '*' OR [Enter the TYPE OF WORK or * for all] = '*'

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

 

[mdlaugh1]

Hey PHV,
thanks!! Works like a charm! I'm being a little dense.. can you explain why it's working.. what is the OR param doing?