Sum Totals from query

[GCLIFTON]

Need your help . I am stuck. The below is the SQL for my query. When i select in the form i need it to group by the (HD SKU)- "So only show the data once if there are multiples" and give me then sum up the (QTY) of that HD SKU










SELECT [Material NSF_TBL_NSF_Data].[Building Number], [Material NSF_TBL_NSF_Data].[Unit Number], [Material NSF_TBL_NSF_Data].[Unit Type], [Material NSF_TBL_NSF_Data].[Scope'], [Material NSF_TBL_NSF_Data].[HD Sku], [Material NSF_TBL_NSF_Data].Description, [Material NSF_TBL_NSF_Data].Unit, [Material NSF_TBL_NSF_Data].Qty, [Material NSF_TBL_NSF_Data].xmcode, [Material NSF_TBL_NSF_Data].Phase, [Material NSF_TBL_NSF_Data].[Hand'], Sum([Total]) AS Expr1, *
FROM [Material NSF_TBL_NSF_Data]
WHERE ((([Material NSF_TBL_NSF_Data].[Building Number]) Like "*" & [forms]![Searchform]![Combo42]) AND (([Material NSF_TBL_NSF_Data].[Unit Number]) Like "*" & [forms]![Searchform]![Unit_Number]) AND (([Material NSF_TBL_NSF_Data].[Unit Type]) Like "*" & [forms]![Searchform]![Unit Type]) AND (([Material NSF_TBL_NSF_Data].[Scope']) Like "*" & [forms]![Searchform]![Scope]) AND (([Material NSF_TBL_NSF_Data].Phase) Like "*" & [forms]![Searchform]![Phase]) AND (([Material NSF_TBL_NSF_Data].[Hand']) Like "*" & [forms]![Searchform]![Hand]));

[ranman256]

then you need 2 queries,
Q1 to pull unique items
Q2 to sum Q1.

[GCLIFTON]

Thank you

Will i have to drop that Q1 data in a table then run a Q2 Sum because currently i am getting a this error message "Cannot Group on fields selected with "*" "