I want to count how many users have 4 or less entries in the table, so, so far i havewhich counts all the entries in the locsLog table and groups them by studentID so tells me how many users have made entries.Code SQL:SELECT COUNT (*) AS fourLOCS FROM (SELECT DISTINCT locsLog.locStudentID FROM locsLog)
How do I limit this so it only gives me a total number of users who have made 4 or less entries. I think I'd need WHERE after the nested SELECT statement, but I don't know what I'd put in it. I triedbut had an error message (I'm doing it with an Access database with ASP and the message was 'Too few parameters. Expected 1').Code SQL:SELECT COUNT (*) AS fourLOCS FROM (SELECT DISTINCT locsLog.locStudentID FROM locsLog) WHERE fourLOCS <= 4
Does anyone have any suggestions please?





Bookmarks