Sharon Hague
Registered User.
- Local time
- Today, 19:46
- Joined
- Jul 10, 2003
- Messages
- 138
Hi
I have a report which runs from a query.
It basically is a report I run each week for each employee which they complete as to what their attendance has been for that week. It also lists if they have any holidays booked for that week. The report is run from a query which has a date parameter field so that I can run my report for whatever time period I wish.
When an employee books a holiday I enter this in my database with the amount of time they have booked. On my report header I have a field called Total Holidays booked which I want it to show what holidays that employee has booked for that year, however I can only get this to show the total for the "date from" and "to" I have specified through my parameter field.
Each week I then run this report it will show the employee what holidays they have booked and have left to use that year.
I'm sure this can be done so I'd appreciate anybodys help on this.
I have a report which runs from a query.
It basically is a report I run each week for each employee which they complete as to what their attendance has been for that week. It also lists if they have any holidays booked for that week. The report is run from a query which has a date parameter field so that I can run my report for whatever time period I wish.
When an employee books a holiday I enter this in my database with the amount of time they have booked. On my report header I have a field called Total Holidays booked which I want it to show what holidays that employee has booked for that year, however I can only get this to show the total for the "date from" and "to" I have specified through my parameter field.
Each week I then run this report it will show the employee what holidays they have booked and have left to use that year.
I'm sure this can be done so I'd appreciate anybodys help on this.
