Null Criteria (Again)

[Tom Knight]

Yesterday i posted about a query effectively ignoring a criteria from a form if the field on the form is left blank. Someone suggested putting Is Null on the second line and that worked for one individual field but I have 6 fields that have criteria in the query. 3 are text fields so i don't need to worry about them the IIf Is Null * takes care of that. Then i have 2 date fields (Between Date 1 And Date 2 on each )and one number field (> And < )
If there is a value in any of the fields i want the relevant criteria to come in to effect, If the field is blank i want to show all the records as if i hadn't entered a criteria.

I've tried building up rows in the query and using Is Null but it doesn't seem to work.
Any ideas... Thanks Tom.

 

[Tom Knight]

Ignore that post.... Access newbie at work!!!

 

[Mile-O]

Even easier than ignoring it would be if you clicked Edit on the first post of the thread and selected delete to delete the whole topic.