Back again...merging tables

[merciless32]

I have 15 different tables. All 15 have 2 common fields, (Date, Status). I need to a cummulative count of record status by date. I am trying to either:

1) Append the data from these fields into a new table representing a combination of all 15 tables.

-OR-

2) Count each table seperately and total the results.

Any ideas?

 

[FoFa]

Have you tried union all to create all the rows, then a query on that query to do the counting?

 

[merciless32]

Ahhh...

Didn't think abut that way.. I'll try it! thanks.