Sum OF Rows with Same Date from Access Db using c#

I have a Access file with multiple columns like TransactionDate total, SubTotal, Tax, Deduction ETC. Now what I need is to add all these values in these columns if there Transaction Date is same. for example if on 30-08-2018 I have 5 different transactions I need the only one record with total of all these transactions.