spatel
Posts: 10
|
| Posted: 10/12/2004, 1:42 PM |
|
Hello,
I have a report which is based on a crosstab qry. The cross tab query gets u
pdated everytime a new payperiod payroll data file is added to its respectiv
e 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 upd
ates 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 exi
sted in the cross-table query.
***********************************************************
This is the way the cross-tab qry looks when ran
Colums
01/10/04 01/24/04 02/07/04 and so on..
JobCodes (Rows)
AA 4 5 8
AAS 3 7 9
Each columns and its data get added everyting one adds a new payperiod file.
|
 |
 |
|
