Solved

Please help with a Query

Posted on 2014-04-22
4
200 Views
Last Modified: 2014-04-22
Experts please help me. I have a table with two fields that I need to work with.
1. GroupID
2. InventoryID

The table might look something like this

GroupID     InventoryID
1                  43
1                  22
1                  23
1                  67
1                  55
3                  21
3                  13

I need a query to return the number of inventoryID's for each type of group in the table.
0
Comment
Question by:Basicfarmer
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 300 total points
ID: 40016078
Try this SQL:

SELECT TableA.GroupID, Count(TableA.InventoryID) AS CntInvID
FROM TableA
GROUP BY TableA.GroupID;

Change TableA to your table name.

mx
0
 
LVL 19

Assisted Solution

by:Raheman M. Abdul
Raheman M. Abdul earned 100 total points
ID: 40016079
Try this:
select groupid, count(inventoryid) as 'TotalInventoryIDs' from tablename groupby groupid
0
 
LVL 33

Assisted Solution

by:Norie
Norie earned 100 total points
ID: 40016082
Try this.

SELECT GroupID, Count(GroupID)
FROM [YourTable]
GROUP BY GroupID
0
 

Author Closing Comment

by:Basicfarmer
ID: 40016089
Thanks for the quick replies. You all had the same thing thing so a gave more points to DatabaseMX since he was first.

Thanks again...
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question