Access newbie needs help! with charts and data order

[olive]

Hi, okay completely new to access. I'm trying to create a chart based on a query with 1 record 8 fields. I can not figure out a way to rearrange the data into two fields 8 records.

The background is I have a hundred units, each with 8 wheels. I have a table with the following fields.
-Unit part number
-Diameter of wheel 1
-Diameter of wheel 2
-Diameter of wheel 3
-Diameter of wheel 4
-Diameter of wheel 5
-Diameter of wheel 6
-Diameter of wheel 7
-Diameter of wheel 8

So, the query tells me how many wheel diameters between a certain range, with the following fields:
- Diameter >530
- 530> Diameter >540
- 540> Diameter >550
- 550> Diameter >560
- 560> Diameter >570
- 570> Diameter >580
- 580> Diameter >590
- 590> Diameter >600

Now I want to plot the range on the x axis and # wheels in that range on the y axis of a bar chart.

Any suggestions on how I can achieve this? How do I create the diameter range as a record rather than a field?

Many thanks!!!

 

[namliam]

Use a union query.

Select Field1 from table
union
Select Field2 from table
union
Select Field3 from table

Good luck

 

[olive]

cheers

that worked great.

I have another problem now. The union query is automatically sorting the data in ascending order and deleting records that contain repeated numbers. How do I turn off both these properties?

Many thanks

 

[olive]

cheers

that worked great.

I have another problem now. The union query is automatically sorting the data in ascending order and deleting records that contain repeated numbers.

For example, I want the data from the different fields to be entered in this order:
6
6
4
3
3
7
19
28

but the datasheet output automatically rearrages the data as:
3
4
6
7
19
28


How do I turn off both these properties?
Many thanks

 

[namliam]

cheers

that worked great.

I have another problem now. The union query is automatically sorting the data in ascending order and deleting records that contain repeated numbers. How do I turn off both these properties?

Many thanks

The sorting cannot really be helped, but shouldnt matter much should it?? Why do you need your recordset to be in a particular order? And can it be achieved by ordering your result on some other field?

To get all Duplicate results, use "Union all" instead of "Union"