calculated field rounding down

[JohnLute]

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!

 

[George Nicholson]

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,

 

[JohnLute]

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

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,

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!