convert result of date claculation to number

[survivo01]

Months left: Format(([Proj Rel]-Date())/30.4,"0.0") I have this date clculation in my query but the result is text instead of number. How can I change to number.

[JoeM]

The FORMAT function returns a text value.

If you are just trying to round it with one decimal place, use:
Months left: Round(([Proj Rel]-Date())/30.4,1)

You can control the format display in the field Properties.