Round up a decimal in a query field

  • Thread starter Thread starter bigomega73
  • Start date Start date
B

bigomega73

Hopefully this is an easy question. How do you round up a number in a query
field? Excel has the ROUNDUP function, but I can't find anything similar in
Access. Can anyone help?
 
Function:round([tablename!fieldname,2]) I think. It may be
round([tablesname!fieldname],2)
 
Thanks Golfinray, but that only rounds to the nearest decimal place. What I
want is the number to be rounded UP. The result that I'm looking for is the
same as the function ROUNDUP in Excel. It basically does the following:

Number Round UP
3.75 4
3.25 4
4.5 5
3 3

Anything with a decimal on it gets automatically rounded up.

Does anyone know how to get this achieved in Access?

Golfinray said:
Function:round([tablename!fieldname,2]) I think. It may be
round([tablesname!fieldname],2)

bigomega73 said:
Hopefully this is an easy question. How do you round up a number in a query
field? Excel has the ROUNDUP function, but I can't find anything similar in
Access. Can anyone help?
Click to expand...
Click to expand...
 
Actually found what I was looking for in another post.

bigomega73 said:
Thanks Golfinray, but that only rounds to the nearest decimal place. What I
want is the number to be rounded UP. The result that I'm looking for is the
same as the function ROUNDUP in Excel. It basically does the following:

Number Round UP
3.75 4
3.25 4
4.5 5
3 3

Anything with a decimal on it gets automatically rounded up.

Does anyone know how to get this achieved in Access?

Golfinray said:
Function:round([tablename!fieldname,2]) I think. It may be
round([tablesname!fieldname],2)

bigomega73 said:
Hopefully this is an easy question. How do you round up a number in a query
field? Excel has the ROUNDUP function, but I can't find anything similar in
Access. Can anyone help?
Click to expand...
Click to expand...
Click to expand...
 
Try this --
Expr2: IIf(Int([YourField])<[YourField],Int([YourField])+1,[YourField])
--
KARL DEWEY
Build a little - Test a little


bigomega73 said:
Thanks Golfinray, but that only rounds to the nearest decimal place. What I
want is the number to be rounded UP. The result that I'm looking for is the
same as the function ROUNDUP in Excel. It basically does the following:

Number Round UP
3.75 4
3.25 4
4.5 5
3 3

Anything with a decimal on it gets automatically rounded up.

Does anyone know how to get this achieved in Access?

Golfinray said:
Function:round([tablename!fieldname,2]) I think. It may be
round([tablesname!fieldname],2)

bigomega73 said:
Hopefully this is an easy question. How do you round up a number in a query
field? Excel has the ROUNDUP function, but I can't find anything similar in
Access. Can anyone help?
Click to expand...
Click to expand...
Click to expand...
 
Yeah, you can return the Integer.

KARL DEWEY said:
Try this --
Expr2: IIf(Int([YourField])<[YourField],Int([YourField])+1,[YourField])
--
KARL DEWEY
Build a little - Test a little


bigomega73 said:
Thanks Golfinray, but that only rounds to the nearest decimal place. What I
want is the number to be rounded UP. The result that I'm looking for is the
same as the function ROUNDUP in Excel. It basically does the following:

Number Round UP
3.75 4
3.25 4
4.5 5
3 3

Anything with a decimal on it gets automatically rounded up.

Does anyone know how to get this achieved in Access?

Golfinray said:
Function:round([tablename!fieldname,2]) I think. It may be
round([tablesname!fieldname],2)

:

Hopefully this is an easy question. How do you round up a number in a query
field? Excel has the ROUNDUP function, but I can't find anything similar in
Access. Can anyone help?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top