formating currency to number

[Rodolfo Fontes]

Hi group,

On a querie, i have two fields (QTD and VALUE). When I do something like
TOTAL : QTD * VALUE, it returns the value on currency. How can i return it
on number?


Thanks,
Rodolfo Fontes

 

[Jeff Boyce]

Rodolfo

Have you set the properties of the query field? Have you tried "forcing"
Access to convert it to "number" (do you mean integer, single, double, ...?)
by using the CInt() (or other) functions?

 

[Rodolfo Fontes]

Jeff,

I didin't tried it... but it works great!

Thanks,
Rodolfo Fontes