P
Pat Z.
I have created a query to show all of the sales for a particular group of
sales reps (leads) by date range showing customer number.
I have a second query for all of the remaining sales reps for the same date
range by customer number.
What I want to do is now find out if there were additional sales on the same
customer made on the same date or later on all of the remaining sales reps.
When I use both of these queries together in a new query, my records are
multiplying if I have more than one of the same customer in the first leads
query.
i.e. cust. # 12345 - sale for $99
12345 - sale for $110
The above sales appear 4 times if I have a match in the remaining sales rep
query.
Hope this makes sense!
Help!
sales reps (leads) by date range showing customer number.
I have a second query for all of the remaining sales reps for the same date
range by customer number.
What I want to do is now find out if there were additional sales on the same
customer made on the same date or later on all of the remaining sales reps.
When I use both of these queries together in a new query, my records are
multiplying if I have more than one of the same customer in the first leads
query.
i.e. cust. # 12345 - sale for $99
12345 - sale for $110
The above sales appear 4 times if I have a match in the remaining sales rep
query.
Hope this makes sense!
Help!