[AccessD] Dynamic Report Based on Crosstab Query

I have a method of doing this that takes only a few minutes. It's
complicated to explain, but if you still need it, let me know.

Linda Ewen
(718) 657-5691


----- Original Message ----- 
From: "Myke Myers" <mmmtbig at bellsouth.net>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, January 29, 2003 1:03 PM
Subject: [AccessD] Dynamic Report Based on Crosstab Query


>
> I have developed an app that uses reports based on crosstab queries.
> Each report looks like a spreadsheet, with a 10-year range of FYs in
> columns across the top. The first column (the "Base" year) has a label
> in the header called 'FY 2003', a textbox in the detail section with a
> control source of '2003', and a total textbox in the footer with a
> control source of ' =sum([2003]). Each column shows the next FY up to
> '2012'.
>
> The client wants to be able select the Base year -- for example, 'FY
> 2004', and have the report dynamically show columns FY 2004 - FY 2013.
> Before I spend several hours writing some code to change the columns in
> the report open event, I want to know if anyone has a better solution.
>
> TIA,
> Myke
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd