Hi
I am busy with a database that prints a report based on Staff overtime, I have a mainform with staff records and a subform with overtime details. The report needs to be printed monthly. It must show the overtime details, per month for each staff member on a indivitual report. How would I query this. I have "staff number as Primary key. I have the report set up but it displays all the records recoded. So effectively it must give me the option of start date and end date, based on the staff number.
Can anyone assit, would really appreciate it
Regards
I am busy with a database that prints a report based on Staff overtime, I have a mainform with staff records and a subform with overtime details. The report needs to be printed monthly. It must show the overtime details, per month for each staff member on a indivitual report. How would I query this. I have "staff number as Primary key. I have the report set up but it displays all the records recoded. So effectively it must give me the option of start date and end date, based on the staff number.
Can anyone assit, would really appreciate it
Regards