How would I make a Union Query out of these two simple tables?

[Bayou BoB]

I would like to make a union query out of these two tables. How would
I go about this? I made an attempt and failed badly! Many thanks.

tbl1
-MedSchedule (name)
MedSchedID
ActDate
Activity
Destination
StaffName
ClientName
Notes

tbl2
-ProgSchedule(name)
ProgSchedID
ActDate
Activity
Destination
StaffName


Many thanks!

K

 

[Duane Hookom]

SELECT
MedSchedID,
ActDate,
Activity,
Destination,
StaffName,
ClientName,
Notes
FROM MedSchedule
UNION ALL
SELECT
ProgSchedID,
ActDate,
Activity,
Destination,
StaffName,
Null,
Null,
FROM ProgSchedule;

 

[___]

SELECT *
FROM tbl1
UNION SELECT *
FROM tbl2;

HT

 

[Duane Hookom]

I don't think this would work since it looks like tbl1 and tbl2 don't have
the same number of fields.