Have 4 Queries and need to combine results

[Trevor W]

I have a payroll program that I have 4 projects and I need to have the gross
Data for each employee that worked in that Pay Period. I have a query for
each project and then a sum query. I would like to have the sum queries to
be displayed in a form so the operator can fill another form with the
deductions. (i.e. Income tax removed, advances, etc.) Then when the form is
done, to print a payslip for the employee based on Employment year and ID.
Can you help?
Trevor W

 

[Klatuu]

It isn't going to work. If by sum query, you mean a total or Group By query,
it can't be edited. If you have a query for each project, then something is
wrong there.

If you have a table for each project, you design is wrong, you should have
one project table with a field to identify the project. If you have one
project with 4 queries against it, why? Wouldn't one query do?

If all you need to present is a sum of hours for each employee, then you
might consider a temporary table to load data into from the other queries and
use that as the record source for your form.

 

[Trevor W]

Hi Klatuu,
The reason I had done a separate table for each is that each project is not
like the other:

I have a Roster Table that has all the employee information, like address,
phone number, DOB, etc.

Then I have a Table for Hourly/Rhubarb work, which is hourly based on hours
per week worked.

Then I have a Table for Strawberry work, which is on a daily basis, but
needs special info like the number of boxes picked and card ref.

Then I have a table for Blueberry work, which is on a daily basis, but needs
to have field raked info and the number of buckets

Then I have a table to track the advances that were given to an employee.
All these tables are linked to Roster Table via Employee Year and Employee
ID.

I have done a marco that allows me to get the information in query datasheet
form, but I would like it to have a popup form with the info filtered to the
employee on the main Form.

All the projects are done as tabs on the main Roster form, as subforms. I
have the report to work too with subreports. Only issue is that I need to
have the Gross Wages for each project for the payperiod. With this info, the
user would be able to press another button and generate a payslip for the
employee.
Thanks,
Trevor W

 

[Klatuu]

I understand.
As I said before, I think the solution is to create a table that will
contain the data necessary to generate a payslip. You would then need to
create append and/or update queries based on your project tables to populate
the pay data.