olive
04-07-2008, 10:48 PM
Here is my dilema
Note I'm new to access
I want to create a chart, Wheel diameter vs number of wheels with that diameter. The chart takes in three sources of information: Wheel Diameter on unit one, Wheel Diameter on Unit 2 and the combined Wheel Diameter of both units with the diameter presented in ranges.
I have extracted this information in a query from a large, established database. The data is in 8 fields, where each field corresponds to a range of the diameters (<530mm, 530-540mm, 540-550mm.....).
Then I realised that I would have to rearrange the data for Unit 1, Unit 2 and combined into columns rather tahn across fields in order to plot, so I used a union query.
However, when I try to join the union queries into one query it concaternates the data, so I end up with multipied data, rather than capturing and transfering the original data from the individual queries.
Am I on the right track, or am I going off on the completely wrong war path. How do I end up with 3 nicely plottable fields in the one query, with the data ordered such that it descends in range (<530, 530to540, 540to550....)
Many thanks!!!!
Note I'm new to access
I want to create a chart, Wheel diameter vs number of wheels with that diameter. The chart takes in three sources of information: Wheel Diameter on unit one, Wheel Diameter on Unit 2 and the combined Wheel Diameter of both units with the diameter presented in ranges.
I have extracted this information in a query from a large, established database. The data is in 8 fields, where each field corresponds to a range of the diameters (<530mm, 530-540mm, 540-550mm.....).
Then I realised that I would have to rearrange the data for Unit 1, Unit 2 and combined into columns rather tahn across fields in order to plot, so I used a union query.
However, when I try to join the union queries into one query it concaternates the data, so I end up with multipied data, rather than capturing and transfering the original data from the individual queries.
Am I on the right track, or am I going off on the completely wrong war path. How do I end up with 3 nicely plottable fields in the one query, with the data ordered such that it descends in range (<530, 530to540, 540to550....)
Many thanks!!!!