Using Not In ( ) with Multiple criteria

[jalge2]

Hey all,

I'm building a query for a Cycle Counter to sort through pick zones. He wants a query that you can use to remove Pick Zones that are scheduled. There are over 30 zones, if there are 3 scheduled, he wants to be able to type in the 3 zones that are scheduled, to show him all of the Cycle Counts that he has to do in other zones.

I tried to add in the criteria


Not IN ([Enter Pick Zones]) and this errored out saying that the expression is too complex. Is there another way to do this?

Thanks for the help.

Jason Alge
Jason.M.Alge@lowes.com

'There are three kinds of people: Those who can count and those who can't'

 

[SkipVought]

Jason,

The string that should appear in the parentheses is like...
[tt]
'zone1','zone2','zone3'
[/tt]
Is that what is entered in [Enter Pick Zone]???

Maybe it should be entered in a textbox and processed by code.

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]