Group Query

[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

 

[Allen Browne]

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.

 

[jervin0831 via AccessMonster.com]

Thank you sir..

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 ?

[quoted text clipped - 7 lines]

plIssID) INNER JOIN tblinventory
ON tblIssueLines.plIssPartID = tblinventory.StockID;