Sorting Fields

[Guest]

I have an Issue with a query in access. In a numeric field why is it that
when sorting the information eiether ascending or decending values are still
mixed up eg

£1187.63
£119
£136.49
£1367.89
£137.34

I can see why it does this I just donk know how to fix it - please can you
help me.

 

[Marshall Barton]

I have an Issue with a query in access. In a numeric field why is it that
when sorting the information eiether ascending or decending values are still
mixed up eg

£1187.63
£119
£136.49
£1367.89
£137.34

Something has formatted the data values and thus converted
to type Text. See if you can find out how that's happening
and get rid of it.

If worst comes to worst, convert it back to a numeris value
to sort:

ORDER BY CCur(thefield)

 

[PC Datasheet]

Your data is text and accordingly what you show is sorted correctly for
text. 1187.63 comes before 119 just as azzzz comes before baaaaa. To sort
this data in numerical order, add the following in a blank field in your
query:
SortField:Val([NameOfYourField])
and sort this column.