Generating an updated report based on a cross-tab query

  • Thread starter Thread starter sam smith via AccessMonster.com
  • Start date Start date
S

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
*****************************************
 
You can go to the design view of the report and edit the Record Source query
every pay period.

--
Duane Hookom
MS Access MVP


sam smith via AccessMonster.com said:
Hello,

I have a report which is based on a crosstab qry. The cross tab query gets
Click to expand...
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
Click to expand...
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
Click to expand...
existed in the cross-table query.
 
Back
Top