How to Fill out One table from Two Queries

[Access.User]

HI,



I have two Query
1- ("QExpCount" contains two column "CountofExpDate" & "DepID" & "CountofDepID")
2- ('QStaffCountDep" contains two column "DepID" & "CountofDepID"),

I want to generate a report contains the results from the above queries like below

DepID	CountofExpDate	CountofDepID
ex. finance	2	8

for this purpose, i created new table ("tbl_ExecutiveRep" contains three column "DepID", "CountofExpDate" "CountofDepID") .

this table "tbl_ExecutiveRep" will be filled when execution of the above queries, so i will delete all records before each query execution.

Your Help is Appreciated.

Thank you

[June7]

Build another query that joins queries on DepID field. Use that query as source for report. Don't really see need for saving to table.

You show 3 fields for query1.

[Access.User]

It's fantastic solution, Thank you very much June7.