AC5FF
Registered User.
- Local time
- Today, 11:01
- Joined
- Apr 6, 2004
- Messages
- 552
I wanted to post this here to see if this has ever happened to anyone ...
I just don't understand how it could happen; based on what I know of Access that is.
I created a quick query to compute the number of labor hours expended against a particular expense account. This ran over a 2yr time period. The first run I had it list every occurance, by date and employee. The 2nd time I changed the HoursTotal from "Group By" to "Sum" in the query to get a quick overview of total time for each employee. That was the only change to the query between the two runs.
However, the total hours for everyone came up different. I was able to narrow that down to one individual; and the difference was only 6 hrs out of over 1200hrs for everyone. (6hrs more on the "SUM" run of the query)
But if the query is pulling the same data; just summing hrs for one and listing them all for the other; how/why would they be different?
I just don't understand how it could happen; based on what I know of Access that is.
I created a quick query to compute the number of labor hours expended against a particular expense account. This ran over a 2yr time period. The first run I had it list every occurance, by date and employee. The 2nd time I changed the HoursTotal from "Group By" to "Sum" in the query to get a quick overview of total time for each employee. That was the only change to the query between the two runs.
However, the total hours for everyone came up different. I was able to narrow that down to one individual; and the difference was only 6 hrs out of over 1200hrs for everyone. (6hrs more on the "SUM" run of the query)
But if the query is pulling the same data; just summing hrs for one and listing them all for the other; how/why would they be different?
