combining queries

  • Thread starter Thread starter Rick Stahl
  • Start date Start date
R

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.
 
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/
 
Got it ! Thank you, Jeff !

..
Jeff Boyce said:
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/
Click to expand...
 
Back
Top