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 >