here it is. i want to return all records if load # is null. or a specific
number that has been entered in to load #. where am i going wrong?

IIf(IsNull([ load # ]),Like "%"or is null ,([ Load # ]))

You want criteria like the following.
WHERE SomeField = [ Load# ] or [ Load# ] is Null

In the query grid (Design view) ienter
Criteria: [ Load# ] or [ Load# ] is Null

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Leslie Porter OHV wrote:
> here it is. i want to return all records if load # is null. or a specific
> number that has been entered in to load #. where am i going wrong?
>
> IIf(IsNull([ load # ]),Like "%"or is null ,([ Load # ]))

damn that was easy. its kinda like trying to as a french guy for a steak but
you only know the words hot dog or hamburger =]

thanks again man

"John Spencer" wrote:

> You want criteria like the following.
> WHERE SomeField = [ Load# ] or [ Load# ] is Null
>
> In the query grid (Design view) ienter
> Criteria: [ Load# ] or [ Load# ] is Null
>
> John Spencer
> Access MVP 2002-2005, 2007-2008
> The Hilltop Institute
> University of Maryland Baltimore County
>
> Leslie Porter OHV wrote:
> > here it is. i want to return all records if load # is null. or a specific
> > number that has been entered in to load #. where am i going wrong?
> >
> > IIf(IsNull([ load # ]),Like "%"or is null ,([ Load # ]))
>