Grouping a field and then Summing the total

[gusc999]

I'm having an issue with the following query I need to group the query by PIRF_SLOT1.SLITEM field and then sum the qty in the PIRF_SLOT1.SLSTK1 field for every item.

SELECT PIRF_SLOT1.SLITEM, PIRF_PIRITEM.ITDESC, PIRF_SLOT1.SLPICK, PIRF_SLOT1.SLDISP, PIRF_SLOT1.SLSTK1, PIRF_SLOT1.SLSTAT, PIRF_ITEMMSC.IMTIE, PIRF_ITEMMSC.IMHIGH, Sum([SLITEM]) AS [ITEM TOTALS]
FROM PIRF_ITEMMSC INNER JOIN (PIRF_PIRITEM INNER JOIN PIRF_SLOT1 ON PIRF_PIRITEM.ITITEM = PIRF_SLOT1.SLITEM) ON PIRF_ITEMMSC.IMITEM = PIRF_SLOT1.SLITEM
ORDER BY PIRF_SLOT1.SLITEM;

 

[dhookom]

Does this work for you? If not, then why?

SELECT SLITEM, Sum([SLSTK1]) AS [ITEM TOTALS]
FROM PIRF_SLOT1
GROUP BY SLITEM
ORDER BY SLITEM;

Duane MS Access MVP
Now help me support United Cerebral Palsy