To change the format of a Simple add query

[TheunsGoosen]

Access beginner,
Hi

I have 3 tables and a query that totals them;
table1 table2 table3 Total
0 2 0 2
0 1 1 2
1 0 2 3
0 0 0 0

To make it more userfriendly, visually, i would like to take out all the zero's in the table1 - 3 but the the Total query does not work, how can i do this?

Thanks
Theuns

 

[genomon]

Please post the SQL behind the "total query".......

Silence is golden.
Duct tape is silver.