Need Help For Comining Two Tables With Same Fields

[suryar]

Hi Mate
I Need A Help To Write Macros That For Two Tables
Table A ( Field 1, Field 2, Field 3, Field Yyyymmdd)
Table B( Field 1, Field 2, Field 3, Field Yyyymmdd)
These Fields Having Some Dynamis Dates
Now We Are Generating Manually, Individually And Copieing In Separate Sheet
Just I Need If I Generate Once Both The Tables Has To Get The Data In One Sheet Or Table.
And Also This Is Weekly Process If I Want To Generate It Dynamically Its Self Please Suggest Me
Thank You

[PEB]

You have to do an Union Query between the tables!
SELECT * FROM Table1
UNION
SELECT * FROM Table 2;

:)