Skip to main content

I have a zip code field and only want 6 different zip codes from over 20 different ones I have in my data source.

I have successfully pulled those with the condition field use 'or'  but I also only want the ones that have an active customer  check marked.  when I place this as the 'or' field it then pulls all the other zip codes I do not want.  I am unable to place an 'and' condition successfully

I have resorted to grouping the active and inactive customers of each selected zip code but I want the inactive and active to be on separate reports (spreed sheet results) not one

What am I doing wrong with my condition codes?

 

In this view, show records
 
Where
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
 
 
 
Be the first to reply!

Reply