I am comfortable writing a sumif formula in excel, but am not as familiar with Access. I have a table that has a list of account numbers and a list of charges on the account. For instance, I have 10 records with the same account number, but different charges for each record. I need to figure out how to query the data so that I can produce a sum of charges for each account number. My excel formula would be, =sumif($C$2:$C$5000,C2,$W$2:$W$5000). I need to to translate that into the appropriate Access format. Any help would be much appreciated.
Thanks!
Bookmarks