formating currency to number

R

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
 
J

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?
 
Top