calculated field rounding down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My query is working fine except that it's calculation is rounding down:

SELECT tblFacilitiesCasesProduced.txtFacilityID, (Format([ProdDate],"mmm""
'""yy")) AS ProdDate1, tblFacilitiesCasesProduced.TotalCasesProduced,
([TotalCasesProduced]\100000) AS DividePer100M
FROM tblFacilitiesCasesProduced;

For the value 255,000 I'm expecting "2.55" however Access is rounding down
to "2.00".

How can I remedy this?

Thanks for your help!
 
How can I remedy this?

By giving it better instructions :-)

\ will give an Integer result (no decimal, but faster *if* appropriate)
/ will give a Floating-point result


HTH,
 
Thanks, George. Dale Fye actually clarified the obvious for me in my
double-post of the same question.

I'm not having the best of days!

--
www.Marzetti.com


George Nicholson said:
How can I remedy this?
Click to expand...

By giving it better instructions :-)

\ will give an Integer result (no decimal, but faster *if* appropriate)
/ will give a Floating-point result


HTH,

JohnLute said:
My query is working fine except that it's calculation is rounding down:

SELECT tblFacilitiesCasesProduced.txtFacilityID, (Format([ProdDate],"mmm""
'""yy")) AS ProdDate1, tblFacilitiesCasesProduced.TotalCasesProduced,
([TotalCasesProduced]\100000) AS DividePer100M
FROM tblFacilitiesCasesProduced;

For the value 255,000 I'm expecting "2.55" however Access is rounding down
to "2.00".

How can I remedy this?

Thanks for your help!
Click to expand...
Click to expand...
 
Back
Top