...sorry...I forgot to include the CustomerID
SELECT Count(ServiceTable.ServiceID) AS CountOfServices, ServiceTable.Customer_ID, ServiceTable.ServiceID
FROM ServiceTable
GROUP BY ServiceTable.ServiceID,ServiceTable.Customer_ID
HAVING (((Count(ServiceTable.ServiceID))>2))
..try this
SELECT Count(ServiceTable.ServiceID) AS CountOfServices, ServiceTable.Customer_ID, ServiceTable.ServiceID
FROM ServiceTable
GROUP BY ServiceTable.ServiceID
HAVING (((Count(ServiceTable.ServiceID))>2))
...this should gt you on the right track...
Hello,
With Tabular forms, Is there anyway to identify and modify a selected row or record.
I am trying to change the background color of the active /selected record.(i.e..when I move from record to record the selected record background is yellow) The problem with the tabular form is that I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.