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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
count function in ACCESS
- Thread starter ilanaz
- Start date
SBendBuckeye
Programmer
Select Count(LastName), LastName
From YourTableName
Group By LastName
Having LastName Like "S*"
Order By LastName;
The group by is what count uses to match everything up. Whenever you use Group By, everything in your select clause must also be in the Group By.
The Having clause is like a Where clause for Group By. In the example above, it would return all LastNames starting with S.
Good Luck!
From YourTableName
Group By LastName
Having LastName Like "S*"
Order By LastName;
The group by is what count uses to match everything up. Whenever you use Group By, everything in your select clause must also be in the Group By.
The Having clause is like a Where clause for Group By. In the example above, it would return all LastNames starting with S.
Good Luck!
- Status
Similar threads
- Locked
- Question
