I have a query in which the criteria is linked to a combo box.

I want to be able to say that if the combo box is empty (Null), then show ALL results.

I have tried this:

IIf(IsNull([Forms]![swboarde2]![reportmonth]),>#01/01/1900#,[Forms]![swboarde2]![reportmonth])

but it won't work.

Does anyone have any suggestions at all?

Thanks

Steve

Try =[Forms]![FormName]![Fieldname] Or IsNull([Forms]![FormName]![FieldName]

If you don't have any luck with that I can send you something.

Hay

No luck I'm afraid, If there is anything you can send me, that would be great.

Steve