Tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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!
 
Hi,



SELECT DISTINCT CustomerName, ServiceItem, ServiceStaff
FROM myTableNameHere




should do.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top