[AccessD] Charts

Stephen Bond stephen at bondsoftware.co.nz
Tue Feb 3 13:30:28 CST 2004


Roz, I have sent you something off line.

Stephen

> -----Original Message-----
> From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
> Sent: Tuesday, 3 February 2004 10:48 p.m.
> To: AccessD (AccessD at databaseadvisors.com)
> Subject: FW: [AccessD] Charts
> 
> 
> Stephen
> 
> I have finally had a go at this and I can't really see how 
> you're making it
> work - yes I am sleepy and slow today.
> 
> I can get my select query showing a row for each month; the 
> trouble is, the
> row is blank apart from the month. To get the correct 
> interpretation for the
> chart (i.e. for months where there is no data the value for 
> each category
> axis should = 0) I am somehow going to have to create a row 
> that contains
> the category and a value of 0 for each category for each month.
> 
> I think I might go back to working out why getting data into 
> Excel is so
> difficult :/
> 
> Roz
> 
> -----Original Message-----
> From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk] 
> Sent: 30 January 2004 09:18
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] Charts
> 
> 
> I don't know about sledgehammer but it sounds like it could 
> do the job... :)
> 
> -----Original Message-----
> From: Stephen Bond [mailto:stephen at bondsoftware.co.nz] 
> Sent: 29 January 2004 19:44
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Charts
> 
> 
> I see what you're up against - I've never been a fan of 
> Access charts .....
> Excel always <uh> excels ....
> 
> I had a bit of a play, I'm afraid my approach has overtones 
> of sledgehammer,
> but tell me what you think:
> 
> I created a new local table called tblMasterMonths, one field 
> called MM,
> type number (byte).  Filled the table with 12 records, values 
> 1, 2, 3, ...
> 12.
> 
> To build the query underlying the Chart, I took the select 
> query I had (the
> one that only shows me January) and altered it to include 
> tblMasterMonths,
> with a Left Join from tblmasterMonths to the query that 
> contains the raw
> data.  This forces months with no data to still have an entry 
> in the output.
> 
> Use the output from this into the Chart.
> 
> Stephen Bond
> 
> 
> > -----Original Message-----
> > From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
> > Sent: Friday, 30 January 2004 7:04 a.m.
> > To: 'Access Developers discussion and problem solving'
> > Subject: RE: [AccessD] Charts
> > 
> > 
> > Sorry Stephen, I guess I wasn't clear enough
> > 
> > I have the column headings set in my cross-tab query and that works 
> > just fine. The problem is when I try to base a line graph on that
> > data... I just
> > can't see a way to do it.
> > 
> > -----Original Message-----
> > From: Stephen Bond [mailto:stephen at bondsoftware.co.nz]
> > Sent: 29 January 2004 17:34
> > To: Access Developers discussion and problem solving
> > Subject: RE: [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
> > > 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


More information about the AccessD mailing list