Totalling a field from multiple tables... (1 Viewer)

[NtriusBIL]

I have two tables with the same field name in each one, 'units' for example. I want to be able to select the sum of 'units' from table A and table B into one overall result.

Of course the first thing I tried was

select sum(units) from tableA, tableB

Access didn't like that because of the identical field names. Am I headed in the right direction, or should I find a way to put all of these things in one table?

 

[RichMorrison]

See Access Help for "Union" queries.

RichM

 

[David R]

or should I find a way to put all of these things in one table?

Why are they separated into two tables presently? Are they coming from different sources, or was this a design choice?