?
Solved

Please help with a Query

Posted on 2014-04-22
4
Medium Priority
?
203 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1200 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 400 total points
ID: 40016079
Try this:
select groupid, count(inventoryid) as 'TotalInventoryIDs' from tablename groupby groupid
0
 
LVL 34

Assisted Solution

by:Norie
Norie earned 400 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying 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

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

719 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