I think this is a cross tab query. HELP

R

Robert Raley

Access 2003



I need help building a query. These are the tables.



wkly_trans_dates

[date_id]

[data_start_date]



wkly_con_stats

[con_stats_id]

[date_id]

[stage_name]

[pvt_min]

[open_min]

[tot_min]

[conv]

[comments]

[suggestions]





wkly_pvt

[con_stats_id]

[seconds]



I would like to create a quiery that I then can use to create a report
showing the following items



this would be selected by [data_start_date]

Sorted and grouped by

[stage_name]

[pvt_min] [open_min] [tot_min] [conv] [pvt_ave, from table
wkly_pvt average( [seconds]/60] [comments] [suggestions]

Past conversions

current-6wk current-5wk current-4wk
current-3wk current-2wk current-1wk current-1wk

[conv] [conv] [conv]
[conv] [conv] [conv] [conv]



Please note that the heading has to change with [conv]



I have steps one and two done works great. I just have not been able to
figure out how to do the history part.



Thanks bob.
 
Top