calculated field rounding down

J

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!
 
G

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,
 
J

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


George Nicholson said:
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 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top