Not Equal to Text (1 Viewer)

[BartK]

I'm halfway there with this, In my macro where the "Where Condition" I would like to string together 3 things that are not equal to the text and then spit out everything else on my report.

EX. [Location] not equal to "home", not equal to [work] etc.

I know the not equal is <> how do I string them together? Or is there an easier way? Thanks

 

[Poppa Smurf]

Using the AND to join the three conditions e.g. ([Location]<>"home") AND ([Location]<>"work") AND ([Location]<>"Bank') etc.

 

[BartK]

Thank you so much. I didn't even think of trying to phrase it that way. Works Beautifully, little on the sluggish side. But I'll take it. Thanks once again.