Data Format

[JonWayne]

If you place a calculated field in a query that results to purely numeric
data, how do you get the resulting datasheet to recognize those values as
numbers rather than text? I want to use that field as a sort field and I
dont want 10 to take ascending precedence over 2, 3, 4, ...

Thanks

 

[Ken Snell [MVP]]

Wrap the expression in an appropriate function, depending upon what type of
"number" you are calculating:

Long integer:
=CLng("your expression")

Integer:
=CInt("your expression")

Double:
=CDbl("your expression")

etc.

 

[JonWayne]

Thanks , that did it. I had done that before anyway, but I wanted an
alternative because that forced me to change the field name.