Text to number

[kowol]

I have a query in a field has following statement.
Monthly Use: IIf([q_partusage_90]![Qty] Is Null,0,Format([q_partusage_90]![Qty]/3,"#.0"))
But the results shows the number as text.
How to get the result as numbers?

Thanks

 

[Beetle]

The Format function returns a string but you can typecast it with CDbl;

Monthly Use: IIf([q_partusage_90]![Qty] Is Null,0,CDbl(Format([q_partusage_90]![Qty]/3,"#.0")))

 

[kowol]

Perfect !

Thanks