Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Decimals
Message
From
21/08/2004 15:20:02
Randy Wessels
Screentek Business Solutions, Llc.
Phoenix, Arizona, United States
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00935202
Message ID:
00935226
Views:
22
Works great, thanks!

>Hi,
>
>Sum(invitempost.qtyord * invitempost.unitpr) As [Ext_Price]
>
> Try either
>
>Sum(ROUND(invitempost.qtyord * invitempost.unitpr,2)) As [Ext_Price]
>
>Or
>
>ROUND(Sum(invitempost.qtyord * invitempost.unitpr),2) As [Ext_Price]
>
>Whichever is more appropriate...
>Regards,
>Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform