Dan, Dan - SMH - Ummm...    Why do you have two identical tables for your companies?  Shame shame.  We'll need to discuss that.  (LOL)

Mean while there is a thing called a Union Query if your tables are exactly the same.  
Those are pretty advanced and require a good bit of SQL knowledge. Covered in Expert 16, the SQL Seminar 1, and
and Union Query TechHelp video

I really recommend the SQL 1 and SQL 2 seminars as soon as you get a chance and have it in your budget.  Those two alone will help take your DBs to the next level.

BTW - since you are a LC member you get a HUGE discount on those.  Don't forget to use the link Richard sent you if you decide to purchase them.

Thanks Scott. Again, i know its bad habit but other systems keep them separate and they wanted everything kept separate so had to fit it to their requirements!!!
Guess they'll just have to wait for the combined report - no dramas

Union Query was perfect. All done, thanks - and something new learned

That is great.  Yeah, in Access you will find there is often more than one way to skin a cat.