Advanced Filter

  • Thread starter Thread starter Fatz
  • Start date Start date
F

Fatz

Hi...I have a query that I run daily and I need to filter out certain
amounts and rep codes. I have tried to use an Advanced Filter...but I
can't get it to do what I need to do. For example...I need to Filter
out all amounts equal to $30,000,000.00 with a rep code of 1.
Currently when I put in the criteria of <>30,000,000.00 under amount
and <>1 under repcode it is eliminating all amounts of $30,000,000.00
not just the amounts where the repcode is one.

Also, when I add more than one criteria it filters nothing. Is (<>)
the best way to filter out amounts and rep codes I don't want? Any
help is appreciated.

By the way...I am going to be adding multiple amounts and reps so any
solution that will account for many criteria is what I need.

Thanks,
Chris
 
Back
Top