Calculation in sql

[Guest]

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

 

[Graham R Seach]

Steve,

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

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia