leezac
asked on
Dates change on Report
I have a database and table where the dates will change and need the report to reflect the different dates when the report is ran. If I create a report with Titles once it seems would need to rebuild the report each time for the new dates. Is there a way not to have to do this. I am thinking to build a table of the dates and add text fileds to the report to refer to dates but I am also using a crosstab query with the date ranges and would need to line the columns up to the text fields.
May look like this one month with dates as headings
11/30/13 12/31/13 1/31/14
1111 5555 abc
nbc
458
and this the next month
2/28/14 3/40/14 4/30/14
My question is whether I can build one report or if a new report will need to be designed each time.
Database7.zip
May look like this one month with dates as headings
11/30/13 12/31/13 1/31/14
1111 5555 abc
nbc
458
and this the next month
2/28/14 3/40/14 4/30/14
My question is whether I can build one report or if a new report will need to be designed each time.
Database7.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks - I am working on testing all the answers.
ASKER