Tracking

B

Bltony

Hi there,

I have a table as following:

CustomerName ServiceItem DateOfService
ServiceStaff
AAA 1234 1/1/2005
Jimmy S
AAA 1234 3/5/2005
Jimmy S
AAA 1234 7/25/2005
Jenifer B
YYY 7890 2/10/2005
John M
YYY 7890 11/10/2005
Sally N
YYY 7890 11/20/2005
John M

I would like to create a query to track Customer who is moving from
ServiceStaff to ServiceStaff for the same ServiceItem. I don't care about the
DateOfService. The result will be listed as:

CustomerName ServiceItem ServiceStaff
AAA 1234 Jimmy S
AAA 1234 Jenifer B
YYY 7890 John M
YYY 7890 Sally N

Please some smart people out there help me. I really appreciate anything you
can help me with.
 
A

apna

Hopefully I can explain this.

Create your query in design view and add CustomerName, ServiceItem, and
Service Staff.
Then on the button bar, press the summation symbol. (looks like a Greek
symbol) If you hold the mouse over it, it will say totals. When you press
that button it adds a TOTAL line into the query form and will be set to
"Group By". Try your query and see if it works!
 
M

Michel Walsh

Hi,



SELECT DISTINCT CustomerName, ServiceItem, ServiceStaff
FROM myTableNameHere




should do.



Hoping it may help,
Vanderghast, Access MVP
 
Top