entering measurements and sorting

[SDKBRK]

I have a column that has measurements and I need to sort them.

Item Name is in the 1st column
Size is in the 2nd column

I did a sort Advance Filter/Sort and it sorted the NAME in the 1st column but when it came to sorting the 2nd column it put 1 1/2" x 2 before 1" x 2".

1" x 2"
1 1/2" x 2"
2 " x 2"
1" 1/2" x 3"

How Do I Make It Sort and give me the 1" before the 1 1/2".

 

[shajueasow]

Hi SDKBRK,
Can you use 1.5 instead of 1 1/2.

 

[Norie]

What type of field is the Size?

If it is a text field then Access will sort it alphabetically rather than numerically.

The only way I can think of to do this sort using your current setup would be to somehow extract the numbers from the Size field.

 

[SDKBRK]

I can not use 1.5 because I have 3/16, 1/4, 1/8, 3/8 and so on. If I change the field from text to number it tells me I will lose some data.

 

[Philem]

Here's a suggestion: Do a one-time table that has fractional to decimal equivalents in it. From there, when you are doing your sorts, bring that conversion table into the query, DISPLAY the fractional size, but SORT by the decimel size.
HTH
P