Crosstab Query - Show date range????

[Guest]

New at crosstab queries, I have built a couple simple ones that show
percentage by week for different depts.

My column heading: Format([DateOfAudit],"ww") returns the number of the
week as a column. Two questions:

Is there a way to return the date range of the week as the column heading
rather than the number of the week?

Second Question:
As time passes the query will naturally grow a new columnm for each week.
How do you build a report that displays the new data without reformatting
every week?

Thanks for you help.

 

[Duane Hookom]

You can create dynamic date crosstab reports using relative dates. There is
an article on how to do this at
http://www.access.hookom.net/DynamicMthlyCrosstabRpt.htm

 

[Guest]

Thanks Hook, I think I am starting to get it but I don't understand the use
of txtEndDate and menuing. I am glad to have found your web stash of
downloads, I'll have to look them over this weekend.
--
Jeff C
Live Well .. Be Happy In All You Do

You can create dynamic date crosstab reports using relative dates. There is
an article on how to do this at
http://www.access.hookom.net/DynamicMthlyCrosstabRpt.htm

--
Duane Hookom
MS Access MVP

New at crosstab queries, I have built a couple simple ones that show
percentage by week for different depts.

My column heading: Format([DateOfAudit],"ww") returns the number of the
week as a column. Two questions:

Is there a way to return the date range of the week as the column heading
rather than the number of the week?

Second Question:
As time passes the query will naturally grow a new columnm for each week.
How do you build a report that displays the new data without reformatting
every week?

Thanks for you help.

 

[Duane Hookom]

txtEndDate is the maximum date you want to reference in your crosstab query.
"Menuing" is the act of selecting menu options from the menu bar.

--
Duane Hookom
MS Access MVP

Thanks Hook, I think I am starting to get it but I don't understand the
use
of txtEndDate and menuing. I am glad to have found your web stash of
downloads, I'll have to look them over this weekend.
--
Jeff C
Live Well .. Be Happy In All You Do

You can create dynamic date crosstab reports using relative dates. There
is
an article on how to do this at
http://www.access.hookom.net/DynamicMthlyCrosstabRpt.htm

--
Duane Hookom
MS Access MVP

New at crosstab queries, I have built a couple simple ones that show
percentage by week for different depts.

My column heading: Format([DateOfAudit],"ww") returns the number of
the
week as a column. Two questions:

Is there a way to return the date range of the week as the column
heading
rather than the number of the week?

Second Question:
As time passes the query will naturally grow a new columnm for each
week.
How do you build a report that displays the new data without
reformatting
every week?

Thanks for you help.