|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 28th, 2005, 06:16 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Tracking
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. 
|
|
#2
November 28th, 2005, 07:22 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Tracking
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! "Bltony" wrote in message ... 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.
|
|
#3
November 28th, 2005, 07:23 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Tracking
Hi,
SELECT DISTINCT CustomerName, ServiceItem, ServiceStaff FROM myTableNameHere should do. Hoping it may help, Vanderghast, Access MVP "Bltony" wrote in message ... 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.
|
|
#4
November 29th, 2005, 11:22 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Tracking
Thanks Michel and Apna. I got it.
"Bltony" wrote: 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Voting Buttons are Not Tracking | JFrost | General Discussion | 5 | November 23rd, 2005 03:28 PM |
| Vote tracking in Outlook 2003 | Peter | General Discussion | 1 | November 18th, 2005 08:15 AM |
| Open new form with related record set? | Rose H. | New Users | 5 | November 3rd, 2005 05:38 PM |
| Garbage at end of document | Lexisch | General Discussion | 2 | December 2nd, 2004 08:35 PM |
Linear Mode
