RoundUp in a Query?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hello everyone,

Is it possible to round up in a query? The reason I am
asking is that I have decimals in my calculations, and
anything pertaining to a decimal needs to be rounded to
the next whole number. My dates are the first day of every
month. My query is below:

SELECT LineData.PlantCode, LineData.LineCode, Sum
(LineData.PlainProd) AS [Total PlainProd]
FROM LineData
WHERE (((LineData.MonthFirst) Between #10/1/2004# And
#12/1/2004#))
GROUP BY LineData.PlantCode, LineData.LineCode
HAVING (((LineData.PlantCode)=39) AND ((LineData.LineCode)
<>"0CNX" And (LineData.LineCode)<>"PCNX"));
 
Use the VBA function Round to do this in the query. Or use this expression
to always round up (good for positive numbers only):

-Int(-[MyValue])
 
Back
Top