Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help Needed!! Stuck in MS Access
...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- tkovirus
- Post #5
- Forum: Microsoft: Access Forms
-
Help Needed!! Stuck in MS Access
This would happen if the Group By field is missing or miss-spelled.- tkovirus
- Post #4
- Forum: Microsoft: Access Forms
-
Help Needed!! Stuck in MS Access
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...- tkovirus
- Post #2
- Forum: Microsoft: Access Forms
-
Tabular Forms
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...- tkovirus
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
