Thread: Sum Group By
View Single Post
Old 10-08-2016, 05:02 AM   #1
MDD
Newly Registered User
 
Join Date: Oct 2016
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
MDD is on a distinguished road
Sum Group By

Hi

I'd like to use a formula similar to SumIf in Access.
I have column 1 with product names and col 2 with Totals.

I would like to show totals for each product in col2.
Just unable to make this happen

I've used code like this -
DoCmd.RunSQL "UPDATE Table1 SET Table1.Col2 = Select Sum(Table1.Col2) FROM Table1 Group By Table1.Col1"

However this throws an error.

Any help much appreciated. Thank you.

MDD is offline   Reply With Quote