Hello All,
I am looking for alittle assistance concerning a totals query. I have 2 tables I would like to get totals grouped by EI_ID. My tables are:
Code:
SD
EI_ID
Event_Date
EVENT_No
SYS_Code
IETM_ID
Code:
SV
IETM_ID
MFID
MOSID
QTY
[TIME]
My query is:
Code:
SELECT SD.EI_ID, SV.MOS_ID, (SV.Quantity*SV.[TIME]) AS SDMH
FROM tbl_AVUM_Scored_Data AS SD INNER JOIN tbl_List_SiteVisit2 AS SV ON SD.IETM_ID = SV.IETM_ID
out put looks like this
EI_ID MOS_ID SDMH
AH0640 15R .8
AH0351 15G .9
AH0318 15R .3
AH0640 15Y 1.4
I am trying to get a list grouped by EI_ID and MOS_ID with totals of the SDMH by MOS_ID.....
I am stuck at the suming of the SDMH by MOS and Grouping by EI_ID
I'd like to get to this:
EI_ID MOS_ID SDMH
AH0640 15R 24.0
XXXXXX 15Y 8.0
AH0351 15G 5.0
XXXXXX 15T 360.0
Any Help will be much appreciated!