Query to ignore form field

[honeypot3]

Hi there

I have a query which uses a form with two unbound fields on it to provide its selection criteria. This works fine when both fields are filled but if a user leaves a field blank because they want a wider search, the query returns no records at all. For example, if I want to find a labourer who earns £500-£700 - no problem but if I just want to find all labourers regardless of earnings (so leave earnings field blank) I get no records. Is there something you can use in an IIf function in the query to ignore the form field's reference?

Thanks Sandra

 

[traingamer]

See faq701-3177

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[honeypot3]

Thanks very much - works like a dream

Sandra

 

[honeypot3]

I have now had to extend the query above so it can also look at several Yes / No fields. Again I need these fields to be ignored if the user chooses not to select them. The Nz option shown previously for unbound text boxes does not seem to work here - i just get a blank query again.