Round up a decimal in a query field

[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?

 

[Golfinray]

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

 

[bigomega73]

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?

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?

 

[bigomega73]

Actually found what I was looking for in another post.

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?

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?

 

[KARL DEWEY]

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

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?

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?

 

[Golfinray]

Yeah, you can return the Integer.

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

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?

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?