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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Count Distinct
Most of my SQL background is with Oracle DBMS' but need to write an MSAccess query that counts the distinct occurances of a value within a table. I can't find the correct syntex for such a query command in MSAccess. Example: An order detail table has multiple rows per order - detailing each...- anna223
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
