Are the dates in the table the primary key? If so, you can simply use the Access query designer to join the two tables on the date field. Drop the date from one of the tables in the first column, amountone from tableA in the second column and amounttwo from tableB in the third column. Then in the fourth column, enter Total: tableA.amountone + tableB.amounttwo.
If the dates in the tables are not unique. Meaning there can be multiple records with the same date, you must first create a query that will sum the amounts grouped by the date. Do this for each table that can have duplicate dates. Then create a query as describe above but use the queries justed created to sum the amounts grouped by date instead of the tables.