SELECT [prt#], Count([prt#]) As CountOfPrt, Sum([qty sold]) As SumOfSold
FROM sales_tbl
GROUP BY [prt#]
You can build that query by starting a new query on your table. Choose
Totals from the View menu. Drag and drop the prt# field twice and the qty
sold field once. Under the second prt# field choose Count on the Totals
line, and under the qty sold field, choose Sum.
Just your basic Totals or aggregate query.
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Mo
Sent: Wednesday, May 03, 2006 8:26 PM
To: [email protected]
Subject: [ms_access] Qry help needed for finding COUNT . Please?
I have a table (sales_tbl) in which there are 3 columns F1 (prt#) F2
(Brand) and F3 (qty sold).
What I'm trying to find is a Count of entries for each part# (F1), as
well as the total Sum of the qty sold (F3).
Is there a specific wizard I should use? Or, does somebody know the SQL
for this?
Thanks-a-bunch,
-Mo
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
