Group Query

  • Thread starter Thread starter lito via AccessMonster.com
  • Start date Start date
L

lito via AccessMonster.com

Hi,

How do i group this query by tblIssue.plIssID ?

SELECT tblIssue.pIssID, tblIssue.pIssDate, tblIssue.pIssTo, tblIssue.pIssBy,
tblIssue.pIssDept, tblIssueLines.plIssQty, tblIssueLines.plIssPrice,
tblinventory.MRN_No, tblIssueLines.plIssPartID, tblinventory.Description,
tblinventory.NSN, tblinventory.PartNo, tblinventory.StockNo
FROM (tblIssue INNER JOIN tblIssueLines ON tblIssue.pIssID = tblIssueLines.
plIssID) INNER JOIN tblinventory
ON tblIssueLines.plIssPartID = tblinventory.StockID;

thanks for any help..

lito
 
1. In query design view, depress the Total button on the toolbar (upper
sigma icon.) Access adds a Total row to the design grid.

2. In the Total row under the fields from tblIssue, accept Group By, or use
First under the fields that are not the primary key. (First is particularly
useful if you have a Memo field.)

3. Decide what kind of grouping you want on the fields from tblIssueLines.
For example, use Count if you want to know how many issue lines there were,
or Sum if you want to know what the total quantity was.
 
Thank you sir..

Allen said:
1. In query design view, depress the Total button on the toolbar (upper
sigma icon.) Access adds a Total row to the design grid.

2. In the Total row under the fields from tblIssue, accept Group By, or use
First under the fields that are not the primary key. (First is particularly
useful if you have a Memo field.)

3. Decide what kind of grouping you want on the fields from tblIssueLines.
For example, use Count if you want to know how many issue lines there were,
or Sum if you want to know what the total quantity was.
How do i group this query by tblIssue.plIssID ?
Click to expand...
[quoted text clipped - 7 lines]
plIssID) INNER JOIN tblinventory
ON tblIssueLines.plIssPartID = tblinventory.StockID;
Click to expand...
Click to expand...
 
Back
Top