View Single Post
  #7 (permalink)  
Old June 2nd, 2007, 08:31 AM
Ashfaque Ashfaque is offline
Authorized User
 
Join Date: May 2006
Location: , , India.
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Ashfaque
Default

 
Quote:
quote:I guess it gives around 12 to 15 digit after decimal point and hence creates problem.
Quote:
Try using something like;

rst!AvgPurPrice = CDbl(Round(AvgPrice, 2))

If you use Sql Server as BE, I advice you to use float data type for the field.

Ashfaque

Reply With Quote