Help with sql statement

Hello,

Please help me with this

I want to list all tables in ms access database and sum of a specific column (I have a column name "total" in all tables).I found sql statement that returns list of table names but how do I get the sum of column "total" from all tables and place next to corespoding table?

I have tried so far

 select table_name from information _schema.columns where column_name="total"

any bit of info would be helpful