Slowlearner
New member
- Local time
- Today, 00:37
- Joined
- May 2, 2008
- Messages
- 2
Hi out there,
I'm having one other problem with Access, if anyone can help me I would soooooooooo appreciate it, I'm so frustrated! I don't have anyone else to help me around here...
I'm using Access '97. My scenario is: I've got survey results for people who have noticed climate changes and effects. I need to make a report with a line graph that shows different fields on the same graph. My x-axis is "date by year", and my y-axis should be "# of people" (but I don't have a separate field for this). The different fields I need to use are "water levels" (which could be high, average, or low) and "temperature" (which could be warmer than most years, or colder than most years).
I am able to make a chart using one field no problem, for example if I make a chart for water levels. To do this I make a query with "date by year" and "water levels" specifying the criteria for "water levels" as either high, average or low. When I create the chart in a report, Access automatically calculates the y-axis for me as a "count". I don't have to specify anything anywhere for it.
But what do I have to do to make the same graph, but only add another field that is independent from the field already in my chart? I would be using the same x and y axis after all. The results would show me the correlation of what people noticed for changing water levels and temperatures each year over time. For example, I would like a chart that plots one line for "water levels" with a "low criteria" to represent low water levels; and one line for "temperature" with a "warmer than most years" criteria to represent high temperatures.
I hope that makes sense...
Thank you!
I'm having one other problem with Access, if anyone can help me I would soooooooooo appreciate it, I'm so frustrated! I don't have anyone else to help me around here...
I'm using Access '97. My scenario is: I've got survey results for people who have noticed climate changes and effects. I need to make a report with a line graph that shows different fields on the same graph. My x-axis is "date by year", and my y-axis should be "# of people" (but I don't have a separate field for this). The different fields I need to use are "water levels" (which could be high, average, or low) and "temperature" (which could be warmer than most years, or colder than most years).
I am able to make a chart using one field no problem, for example if I make a chart for water levels. To do this I make a query with "date by year" and "water levels" specifying the criteria for "water levels" as either high, average or low. When I create the chart in a report, Access automatically calculates the y-axis for me as a "count". I don't have to specify anything anywhere for it.
But what do I have to do to make the same graph, but only add another field that is independent from the field already in my chart? I would be using the same x and y axis after all. The results would show me the correlation of what people noticed for changing water levels and temperatures each year over time. For example, I would like a chart that plots one line for "water levels" with a "low criteria" to represent low water levels; and one line for "temperature" with a "warmer than most years" criteria to represent high temperatures.
I hope that makes sense...
Thank you!
