Trouble with suming, grouping records

[mrfixit1170]

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:

SD
EI_ID
Event_Date
EVENT_No
SYS_Code
IETM_ID

SV
IETM_ID
MFID
MOSID
QTY
[TIME]

My query is:

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!

[mrfixit1170]

I guess I had a brain fart sorry for the waste of time....
My code

 
SELECT sd.EI_ID, sv.MOS_ID, Sum([sv].[Quantity]*[sv].[Time]) AS SDMH
FROM dbo_tbl_AVUM_Scored_Data AS sd INNER JOIN dbo_tbl_List_SiteVisit2 AS sv ON sd.IETM_ID = sv.IETM_ID
GROUP BY sd.EI_ID, sv.MOS_ID;