critera error in 2003 saying to complex

L

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

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
 
L

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

John Spencer said:
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 # ]))
Click to expand...
Click to expand...
 
Top