Roz Clarke
roz.clarke at donnslaw.co.uk
Tue Feb 3 03:48:24 CST 2004
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