New Dates in Reports

[rich808]

I have a table I update every day. After updating, I generate a report based on a query which works fine. I also run a cross-tab report that displays the last ten days of information. It worked fine yesterday, but when I updated the main table today and ran the cross-tab report, the most current date hadn't changed from yesterday to today. What can I do to have the cross-tab report show the current date in addition to the previous nine days? Thanks in advance.

 

[nka]

I think I am trying to do something similar and also need some help!

My crosstab query works lovely and looks fantastic in my formatted report... The report shows sick records by department, by employee over a 13 month rolling period.

So! My dilema is how to "dynamically" (or magically) populate the fields with the current 13 months. In the past I have copied the previous months' report, deleted the last month, shuffled the remaining 12 fields 1 step to the right, inserted the latest month at the front and re-assigned the months one by one.. phew! mammoth exercise every month as you can see!

If there were some way in which I could say field A = data in column 1 etc etc I would be very happy indeed!

Does anyone understand what I am looking for and how I can get it? Please??

NKA