RE: How to count records w/o counting duplicates by week, month, or ye
- From: John <John@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 17 Apr 2009 14:28:07 -0700
All very helpful... If I have a follow-up I'll post back..
--
Thanks in advance!
**John**
"John" wrote:
I have a table with payroll data. I have an employe ID, a week ending date.
(Sunday), and hours worked on Sun, Mon, Tue, ... Sat. What I need is a query
that counts the number of employees, and gives total hours worked on what
days. The catch is that overtime and double-time hours are shown on a
different record, with the same week ending date. If I do a simle count of
employee ID, I get 2x the number of real employees. Not all employees work
over time or double-time.
Fields:
WeDte: week ending date
EmpID: Employee ID (text)
Mon: Monday Hours
Tue: Tuesay Hours
Etc. through "Sat: Saturday Hours"
WgRate: Employee Wage Rate
What I would like to do is to group the qery by week, month, quarter, or
year to get the total hours, salary cost, and employee count. The hours and
salary cost is not an issue, but counting the first EmpID in the month, and
then not counting it until the next month is killing me!
--
Thanks in advance!
**John**
- References:
- Prev by Date: Re: PrimaryKey Failing
- Next by Date: Updatequery in Access 2003
- Previous by thread: RE: How to count records w/o counting duplicates by week, month, or ye
- Next by thread: Duplicate Record in query results - show only once
- Index(es):
Relevant Pages
|
