erm..numbers..currency etc

[noaksey]

right people!

i have a table with about five fields. one of the fields is calle
price. example of one value in this is £66.64 (currency and 2d.p)

i have made a query that should sort the prices by the ones only ove
50 quid (>50)

but for some reason...it dont work!! it still displays all of th
prices even under 50 quid! i know somewhere theres an obvious answe
but i can't seem to see where the problem is!! if anyone could helpm
that'll be great.

cheers,
chris

 

[Michel Walsh]

Hi,


It may be you have strings rather than numbers. "z" is greater than
"ab", so "9" > "10" for the same reason... Even if clearly, the number
9 is < than the number 10. Check the field, and also check the criteria (in
SQL view) to see if it is not written "50" instead of 50.


Hoping it may help,
Vanderghast, Access MVP