G
Guest
Hello
I built a crosstab query that serves as the recordsource for my report. The crosstab query searches for employees that worked a given month, and if so, displays the hours they worked. The crosstab query's rows are the days of a specified month (if Jan, then dates range from 1/1 - 1/31); the columns are the employees, and the values are the hours they worked.
My report's date header contains labels for date and employee names; the detail section lists the date and the hours worked for each employee. If I query a different month, will the report labels specifying the employees change (I'm doubting this...) or do I need to create a new report each month? I would like to have the report be stand-alone and update itself... but I don't know the best way to do this.
Any suggestions
Much thanks
Nadia
I built a crosstab query that serves as the recordsource for my report. The crosstab query searches for employees that worked a given month, and if so, displays the hours they worked. The crosstab query's rows are the days of a specified month (if Jan, then dates range from 1/1 - 1/31); the columns are the employees, and the values are the hours they worked.
My report's date header contains labels for date and employee names; the detail section lists the date and the hours worked for each employee. If I query a different month, will the report labels specifying the employees change (I'm doubting this...) or do I need to create a new report each month? I would like to have the report be stand-alone and update itself... but I don't know the best way to do this.
Any suggestions
Much thanks
Nadia