Calculation in sql

S

steve

hi,

I have made a qry but something is wrong
Decimal * decimal * money
0.5 * 1 *1 €
= .500000
Need to be 0.50000

What’s the best way to correct this?

thanks
 
G

Graham R Seach

Steve,

Set the control's Format property as follows:
"0.000000"

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top