Sum in Query

[stu_C]

Hi all
in a query I have simple sum to work out how many miles till a service



MilageLeftTillService: nz([ServiceMilage])-nz([CurrentMilage])

in the query I want it to pick up when there is a 1000miles or less to go till service.

in the criteria I have put in <="1000" but its not picking them up it shows everything and not sure why?

[rpeare]

you're comparing it to a text value not a number value

try <=1000