Generating an updated report based on a cross-tab query

[sam smith via AccessMonster.com]

Hello,

I have a report which is based on a crosstab qry. The cross tab query gets updated everytime a new payperiod payroll data file is added to its respective table; however my report dosen't reflect the changes with the new data.

Basically, everytime I add a new payperiod file, it creates a new column in the table for that payperiod which then get reflected in my cross-tab query. So If I had payperiod 01/10/04 initially and then if I add 01/24/04, it updates it in the table and then the cross-tab query but in the report it only has payperiod 01/10/04 because thats the only column existed originally when I created that report via the wizard.

How can I get the report to run so it captures all the columns currently existed in the cross-table query.

thanks
_________________
spatel

*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=1e7b581adcc640fb940fdf7af2c84f6a
*****************************************

 

[Duane Hookom]

You can go to the design view of the report and edit the Record Source query
every pay period.

--
Duane Hookom
MS Access MVP

Hello,

I have a report which is based on a crosstab qry. The cross tab query gets

updated everytime a new payperiod payroll data file is added to its
respective table; however my report dosen't reflect the changes with the new
data.

Basically, everytime I add a new payperiod file, it creates a new column

in the table for that payperiod which then get reflected in my cross-tab
query. So If I had payperiod 01/10/04 initially and then if I add 01/24/04,
it updates it in the table and then the cross-tab query but in the report it
only has payperiod 01/10/04 because thats the only column existed originally
when I created that report via the wizard.

How can I get the report to run so it captures all the columns currently

existed in the cross-table query.