combining queries

[Rick Stahl]

I have 2 queries I wish to combine, one contains weekly hourly employee
payroll (WHEP) data and the other weekly salary payroll (WSP) data. I do
not know how to combine or link them so that when I enter a specific date,
both the WHEP and WSP data are listed into a single query. Although
employee ID is unique for the each query (an hourly employee cannot be a
salaried employee or visa versa), all the field names in the WSP are also in
the WHEP and therefore is a subset. The WHEP also contains extra field
names not in the WSP that I also wish to list; therefore these fields will
be blank for the WSP employees. Thank you.

 

[Jeff Boyce]

Rick

Take a look at Access HELP concerning UNION queries. The gist of it is that
you'll create one query for your first set of data (?WHEP) and a second
query for the second set (?WSP), and include "dummy" fields in the second so
that the two sets "line up".

Then create a third query, a UNION query, that puts the first two sets
together.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Rick Stahl]

Got it ! Thank you, Jeff !

..

Rick

Take a look at Access HELP concerning UNION queries. The gist of it is
that
you'll create one query for your first set of data (?WHEP) and a second
query for the second set (?WSP), and include "dummy" fields in the second
so
that the two sets "line up".

Then create a third query, a UNION query, that puts the first two sets
together.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/