[AccessD] Charts

Making an assumption here that you have a Cross-tab Q with the month column header formatted MM ...

* go to Query Properties, and put something like this in the 'Column Headings' entry: 1;2;3;4;5;6;7;8;9;10;11;12

This will force a column heading for each month.

Stephen Bond

> -----Original Message-----
> From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
> Sent: Friday, 30 January 2004 5:54 a.m.
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Charts
> 
> 
> Hi all. Hope everyone is well.
> 
> I have a problem with a chart I need to display in Access. I 
> used to do this
> by exporting data to Excel but the connection to Excel has 
> been so slow and
> unstable that I am now trying to bring it within Access.
> 
> The data I need to display is in a cross-tab query, where I 
> have categories
> as the row header and months of the year as the column 
> header. I need to
> show all the months even though we currently have data only 
> for January.
> 
> If I base the chart on the cross-tab, I cannot see a way to 
> tell it that
> each column should be an axis entry. If I base the chart on a 
> select query,
> it correctly allows me to set 'month' as an axis, but only 
> shows me January.
> 
> Can anyone help?
> 
> TIA
> 
> Roz
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>