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

quote:I guess it gives around 12 to 15 digit after decimal point and hence creates problem.
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.


Reply With Quote