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.
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.