critera error in 2003 saying to complex

[Leslie Porter OHV]

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 # ]))

 

[John Spencer]

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]

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

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

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 # ]))