<div>
Thanks for the quick replies. You all had the same thing thing so a gave more points to DatabaseMX since he was first.<br />
<br />
Thanks again...
</div>


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...

<div>
<div class="content wysiwyg-content">
Experts please help me. I have a table with two fields that I need to work with.<br />
1. GroupID<br />
2. InventoryID<br />
<br />
The table might look something like this<br />
<br />
GroupID &nbsp; &nbsp; InventoryID<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;43<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;67<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;55<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13<br />
<br />
I need a query to return the number of inventoryID's for each type of group in the table.
</div>
</div>


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.

Please help with a Query

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.