I'm creating a query from a table of suppliers, and I need to show a count of the number of suppliers in each state sorted by state. I'm quite new to access, and would appreciate any help or advice! Thank you!
Novice
Windows 7 64bit 
Access 2010 64bit
I'm creating a query from a table of suppliers, and I need to show a count of the number of suppliers in each state sorted by state. I'm quite new to access, and would appreciate any help or advice! Thank you!
VIP
Windows XP Access 2010 32bit
Try an aggregate (Totals) query with grouping on suppliers and state. Access Help has guidelines on creating Totals queries.
Or build a report and use Grouping & Sorting features with aggregate calcs in group footer. Again, Access Help has guidelines on building reports.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Query to count number of new customers per month
Posting Permissions
Reply With Quote