[AccessD] Dynamic Report Based on Crosstab Query

Andy Lacey andy at minstersystems.co.uk
Wed Jan 29 15:45:01 CST 2003


Hi Myke
Well you'll probably spend hours writing code but the basis of it is in
Solutions.MDB

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Myke Myers
> Sent: 29 January 2003 18:03
> To: accessd at databaseadvisors.com
> 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/a> ccessd
> 




More information about the AccessD mailing list