K
Karl
Hello,
I have a time database to keep track of hours worked on projects. However I
have three queries that I use to double check the data. The first query is a
make table query that queries out total time worked that is chargeable and
non-chargeable (administration). This queries seems to be calculating out the
correct hour values and has 5 fields, which are:
Note: Project Code 888 is vacation time and is not included in the queries.
Employee Query:
Field Employee Hours Pay Period Date
Project Code
Table Employee Table 03 Time 01 Year 2007 01 Year 2007 03
Time
Total Group By Sum Group By Group by
Group by
Sort
Show (all are shown)
Criteria "July"
Not Like "888"
The second query is supposed to only query out charegeable time and is set up:
Chargeable Query:
Field Employee Hours Pay Period Date
Project Code
Table Employee Table 03 Time 01 Year 2007 01 Year 2007 03
Time
Total Group By Sum Group By Group by
Group by
Sort
Show (all are shown)
Criteria "July"
<> "999" and
Not Like "888"
and Not Like "P*"
The Project code is supposed to not select project codes 999 because they
are non-chargeable and not select 888 because it is vacation and no project
codes starting with P because they are proposals and are non chargeable.
This query is not working correctly as it gives me different total hours for
projects the employee query gives me for a project. I.e employee query says
the total hours worked for project 702 is 17.75 while the chargeable query
says their is only 17.25 hours for project 702 (which is incorrect). However
for some reason it is only miscalculating for a couple of projects and
employees.
The third query only calculates adminstration time (i.e. non-chargeable) and
is set up similarily:
Chargeable Query:
Field Employee Hours Pay Period Date
Project Code
Table Employee Table 03 Time 01 Year 2007 01 Year 2007 03
Time
Total Group By Sum Group By Group by
Group by
Sort
Show (all are shown)
Criteria "July"
"999" or
Like "P*"
This one too is miscalculating for one employee by a couple of hours.
As you can see all the queries are based on the same fields so I can't
understand why one would be calculating a different value then the other. Is
it possible the problem lies elsewhere like in my report as each of these
queries is a make table query which makes a table that is then used in a
summary report . However, I don't think this should be the problem.
Any advice on where my problem lies would be greatly appreciated.
Thanks,
I have a time database to keep track of hours worked on projects. However I
have three queries that I use to double check the data. The first query is a
make table query that queries out total time worked that is chargeable and
non-chargeable (administration). This queries seems to be calculating out the
correct hour values and has 5 fields, which are:
Note: Project Code 888 is vacation time and is not included in the queries.
Employee Query:
Field Employee Hours Pay Period Date
Project Code
Table Employee Table 03 Time 01 Year 2007 01 Year 2007 03
Time
Total Group By Sum Group By Group by
Group by
Sort
Show (all are shown)
Criteria "July"
Not Like "888"
The second query is supposed to only query out charegeable time and is set up:
Chargeable Query:
Field Employee Hours Pay Period Date
Project Code
Table Employee Table 03 Time 01 Year 2007 01 Year 2007 03
Time
Total Group By Sum Group By Group by
Group by
Sort
Show (all are shown)
Criteria "July"
<> "999" and
Not Like "888"
and Not Like "P*"
The Project code is supposed to not select project codes 999 because they
are non-chargeable and not select 888 because it is vacation and no project
codes starting with P because they are proposals and are non chargeable.
This query is not working correctly as it gives me different total hours for
projects the employee query gives me for a project. I.e employee query says
the total hours worked for project 702 is 17.75 while the chargeable query
says their is only 17.25 hours for project 702 (which is incorrect). However
for some reason it is only miscalculating for a couple of projects and
employees.
The third query only calculates adminstration time (i.e. non-chargeable) and
is set up similarily:
Chargeable Query:
Field Employee Hours Pay Period Date
Project Code
Table Employee Table 03 Time 01 Year 2007 01 Year 2007 03
Time
Total Group By Sum Group By Group by
Group by
Sort
Show (all are shown)
Criteria "July"
"999" or
Like "P*"
This one too is miscalculating for one employee by a couple of hours.
As you can see all the queries are based on the same fields so I can't
understand why one would be calculating a different value then the other. Is
it possible the problem lies elsewhere like in my report as each of these
queries is a make table query which makes a table that is then used in a
summary report . However, I don't think this should be the problem.
Any advice on where my problem lies would be greatly appreciated.
Thanks,