Sorting Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
Click to expand...


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)
 
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.
 
Back
Top