Rupert Bennett
Active Member
- Joined
- Nov 20, 2002
- Messages
- 271
After numerous unsuccessful attempts, I have come to the realization that I need some help with this. Although my query returns the results I asked for, it does not present the data that would make it useful for a report or a form. This query lists all instances of each person who has taken vacation this year and how many hours were taken each time. However, for use in a report, I would like the data summarized, so that if someone had multiple instances of vacation taken, that name would be listed once only and a total given for the number of hours used for the year so far for that person.
I have tried a crosstab query, but my lack of knowledge in this area, caused it to return the data in just about the same manner as the select query.
The fields in my query are; Empl#, FirstName, LastName, StartDate, EndDate, HoursUsed. I would be extremely grateful to anyone who could tell me in some detail what type of query I should use and how to structure it to return the data in the manner stated above.
TIA
Rupert
I have tried a crosstab query, but my lack of knowledge in this area, caused it to return the data in just about the same manner as the select query.
The fields in my query are; Empl#, FirstName, LastName, StartDate, EndDate, HoursUsed. I would be extremely grateful to anyone who could tell me in some detail what type of query I should use and how to structure it to return the data in the manner stated above.
TIA
Rupert