Jan-December chart with specific information
-
I have a table in MS Access 2007 database I want to make a chart with, column chart (or whichever one is vertical). The table holds information on various species of insect I recorded over the year, so I could have multiple records for one species. Anyway what I have wanted to do, but haven't been able to figure out what is that: I wanted to make a chart that had Jan, feb, march (all the way to december) on the X axis and up the Y axis I wanted a number (not sure of the number needed on it, up to 500 possibly) and what I wanted to do with the chart is show how many of a particular species I found each month of the year. The fields I wanted to get the information with from the table are the scientific name, date, stage and quantity. The scientific name will be displayed as the title of the table and this is the species I want to find out about. The date is the date that month I recorded the species and the quantity is how many I recorded on that date. I have another field which is called "stage" and when you open the chart it will ask you two things, the scientific name and the stage as the stage (adult, larvae etc...) is quite inomrtant to what I want and I want the stage to be displayed on the chart. Just say I wanted to know about Pieris Napi, I want to type this in when I open the chart, next type in Adult as the stage and I would get a chart showing Jan-December and the total I found each month in a column chart with its scientific name dispayed on title and stage (wether its an adult or pupae etc..) Anyone know how would I do this? I think I would need to make a query from the table to get the information on the scientific name and stage, but not sure what else to do, any help would be appreciated.
In the end we're all just the same
-
I have a table in MS Access 2007 database I want to make a chart with, column chart (or whichever one is vertical). The table holds information on various species of insect I recorded over the year, so I could have multiple records for one species. Anyway what I have wanted to do, but haven't been able to figure out what is that: I wanted to make a chart that had Jan, feb, march (all the way to december) on the X axis and up the Y axis I wanted a number (not sure of the number needed on it, up to 500 possibly) and what I wanted to do with the chart is show how many of a particular species I found each month of the year. The fields I wanted to get the information with from the table are the scientific name, date, stage and quantity. The scientific name will be displayed as the title of the table and this is the species I want to find out about. The date is the date that month I recorded the species and the quantity is how many I recorded on that date. I have another field which is called "stage" and when you open the chart it will ask you two things, the scientific name and the stage as the stage (adult, larvae etc...) is quite inomrtant to what I want and I want the stage to be displayed on the chart. Just say I wanted to know about Pieris Napi, I want to type this in when I open the chart, next type in Adult as the stage and I would get a chart showing Jan-December and the total I found each month in a column chart with its scientific name dispayed on title and stage (wether its an adult or pupae etc..) Anyone know how would I do this? I think I would need to make a query from the table to get the information on the scientific name and stage, but not sure what else to do, any help would be appreciated.
In the end we're all just the same
I think you probably want to use a parametrized query with species as input. I'm slightly confused about the stage - should the chart only show the selected stage or all stages? If you go this route then the query should group by month and stage. That should easily be done in designer. An alternative might be to use a PivotTable as the source for the chart. My Access is pretty rusty but I think this is fairly straightforward. I'm not too good on charts - never really used them in Access. Would it be better to give the user a list of species and allow them to select from the list. Saves all sorts of bother if the user gets the spelling wrong.
Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis The only valid measurement of code quality: WTFs/minute.
-
I think you probably want to use a parametrized query with species as input. I'm slightly confused about the stage - should the chart only show the selected stage or all stages? If you go this route then the query should group by month and stage. That should easily be done in designer. An alternative might be to use a PivotTable as the source for the chart. My Access is pretty rusty but I think this is fairly straightforward. I'm not too good on charts - never really used them in Access. Would it be better to give the user a list of species and allow them to select from the list. Saves all sorts of bother if the user gets the spelling wrong.
Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis The only valid measurement of code quality: WTFs/minute.
Hi Dave, First, for stage, prefer a drop down list to choose the stage and the results change accordingly, just show one type of stage, say a table showing the Pieris Napi at adult stage only. What you suggested on having a drop down list to chose the scientific name would be far better, how would I do this so you can choose what you want proir to creating the table, would an input form work best for this, choose the scientific name and stage on a small form then press a button to take you to a chart on that species. I know how to create the form, but not how to get the information onto a chart Havn't used much with charts or inputting data except on tables latley, so I am a bit rusty.
In the end we're all just the same