J
JWeaver
I have a query that returns all records pertaining to a particular payroll
period for employees. I need to make a new query that will total the number
of hours worked by each employee and return ONLY those whose total number of
hours is over 80. I then want to use it in a report to obtain the detail of
the records that were used to make up over 80 hours. I have tried adding a
calculated field to do this but the total in this field is the same as the
number of hours shown for that particular week, and therefore, doesn't give
me what I want.
I have a Summary Report that I use that gives me the totals for everyone for
a particular payroll period but I haven't been able to change it to display
what I want either so I thought a new query might work better.
Any help you can give me would be appreciated.
period for employees. I need to make a new query that will total the number
of hours worked by each employee and return ONLY those whose total number of
hours is over 80. I then want to use it in a report to obtain the detail of
the records that were used to make up over 80 hours. I have tried adding a
calculated field to do this but the total in this field is the same as the
number of hours shown for that particular week, and therefore, doesn't give
me what I want.
I have a Summary Report that I use that gives me the totals for everyone for
a particular payroll period but I haven't been able to change it to display
what I want either so I thought a new query might work better.
Any help you can give me would be appreciated.