Hi Everyone,
I have a problem with Ms Access and can't seem to figure out a good way to do it !!
I have a to write a query to which picks out how many times a customer has come into the shop for servicing (it should only pick those who have come more then once). The following are the tables:
Customer Table:
CustomerID
LastName
FirstName
Address
Suburb
Postcode
Service_ID
Service Table:
ServiceID
ServiceDescription
Hours
ServiceCharge
GST_Required
Customer_Id
How do I write the query ?? I have tried all I know and cant figure it out. Can anyone help me please. Any Suggestions would be greatly appreciated.
I have a problem with Ms Access and can't seem to figure out a good way to do it !!
I have a to write a query to which picks out how many times a customer has come into the shop for servicing (it should only pick those who have come more then once). The following are the tables:
Customer Table:
CustomerID
LastName
FirstName
Address
Suburb
Postcode
Service_ID
Service Table:
ServiceID
ServiceDescription
Hours
ServiceCharge
GST_Required
Customer_Id
How do I write the query ?? I have tried all I know and cant figure it out. Can anyone help me please. Any Suggestions would be greatly appreciated.