cross tab query

ozip dzip week no1 week no2 week no3

i have the above fields in a cross tab query. columns week no1 , week
no2 and so on could be dynamic-- it could also be week no52, week no
51 etc. user will enter the date as --- between 1/1/2009 and 2/1/2009
or something

nowi i am trying to create a report based on the above query using
report wizard--- how should i create a report when column names keep
on changing based on what the user need

what should be the column names in a report- i create the report by
report wizard--- pls help step by step instructions

i am new to this thanks

There is a solution for this but monthly at
http://www.tek-tips.com/faqs.cfm?fid=5466. This can be modified from months
to weeks quite easily.

--
Duane Hookom
Microsoft Access MVP


"subs" wrote:

ozip dzip week no1 week no2 week no3

i have the above fields in a cross tab query. columns week no1 , week
no2 and so on could be dynamic-- it could also be week no52, week no
51 etc. user will enter the date as --- between 1/1/2009 and 2/1/2009
or something

nowi i am trying to create a report based on the above query using
report wizard--- how should i create a report when column names keep
on changing based on what the user need

what should be the column names in a report- i create the report by
report wizard--- pls help step by step instructions

i am new to this thanks
.