Calculated fields in sql query rounding

  • Thread starter Thread starter Gav
  • Start date Start date
G

Gav

Is there a way to stop calculated fields rounding? I'm doing some queries
such as SUM(quantity) /9 etc..etc but it keeps rounding them all down. I
need it to stop doing this.

Can anyone help

Thanks
Gav
 
I think that the calculation is not rounding it, but instead the format
of the field you are seeing it in is. It may also be that the field
"quantity " is not formatted to support fractional numbers - make sure
it is at least single precision, not Long integer, which is the default
numeric type.

Pavel
 
Hi Gav,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. If you have any
questions or concerns, don't hesitate to let me know. We are here to be of
assistance!

We appreciate your patience and look forward to hearing from you!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Back
Top