Writing results of multiple queries to a table

[FireViking]

Hi all,
I have 1 table that has date fields to record different activities.
I need 4 queries to pull data from the table to show the activity within a specified time frame.

The question i have is how can I write the data pulled from all queries to 1 table to use on report.

Cheers

 

[smedvid]

Well...
4 seperate queries using the INSERT...
Or if applicable, 1 big query with an INSERT and UNION clause that can combine all 4 into 1 table.
htwh... Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/