Need some direction and syntax. Preemptive thanks for your advice. I can use select expert to get all customers of a specific types, but how would I exclude if customer is any other type?
cust, type#
Ed, 1
John, 2
Ed, 3
Bert, 2
John, 99
Most of the time a customer will have many different types.
Very rarely will a customer have just one or two types
Im trying to create a report which displays customer with a specified type#(s), kicker is, if customer has any other type, I don't want to display customer at all.
Ex. I want only customer type 1 and 2 but if they are also customer type 3, 4, 5,...,99 I don't want to see them. *Table above should only show Bert.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum