combining queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick Stahl - 20 Nov 2007 01:28 GMT

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.

Reply to this Message

Jeff Boyce - 20 Nov 2007 01:43 GMT

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.

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

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

> 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
[quoted text clipped - 5 lines]
> names not in the WSP that I also wish to list; therefore these fields will
> be blank for the WSP employees. Thank you.

Reply to this Message

Rick Stahl - 20 Nov 2007 03:06 GMT

Got it ! Thank you, Jeff !

.

> Rick
>
[quoted text clipped - 20 lines]
>> will
>> be blank for the WSP employees. Thank you.

Reply to this Message