Clarification of relationship b/w queries and reports

[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

 

[Chris Sergent]

Nadia,
Delete your labels and replace them with text boxes and
have the text boxes reference the dates you are using by
calculation or a form reference.

Your dates will automatically update then.

-----Original Message-----
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.

 

[Guest]

Yes, that has already been done, however, I was wondering if the column headings (which are just labels) will also update.

 

[Chris Sergent]

Your column headings are what I am referring to. You need
to change them to text boxes. Your labels will not update.
You can assign the date field to the text box in your
header. If it is a fixed date, a DateAdd() Function would
probably work for you.

-----Original Message-----
Yes, that has already been done, however, I was wondering

if the column headings (which are just labels) will also
update.