Round up all values

Posted by Shaun on Stack Overflow See other posts from Stack Overflow or by Shaun
Published on 2010-04-01T10:17:16Z Indexed on 2010/04/01 10:23 UTC
Read the original article Hit count: 311

Filed under:

ms-access-2003

On a report I have the following code

=Sum([PartQty]*[ModuleQty])

Example results are 2.1 or 2.6, what I need is for the valule to round up to read 3

Related posts about ms-access-2003

MS Access 2003 - ordering the string values for a chart not alphabetical

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is a silly question. Lets say I have a query that produces for a list box, and it produces values for three stores Store A 18 Store B 32 Store C 54 Now if I ORDER BY in the sql statement the only thing it will do is descending or ascending alphabetically but I want a certain order… >>> More
MS Access 2003 - Embedded Excel Spreadsheet on Access form

as seen on Stack Overflow - Search for 'Stack Overflow'
lets say I have an embedded Excel Spreadsheet on a Microsoft Access form. I call the object frame ExcelFrame and I add a text box on the form called txtA1 and I add a button on the form called cmdInsert I want to type "Hello World" into the text box, click the button and have it appear in… >>> More
MS Access 2003 - Message Box: How can I answer "ok" automatically through code

as seen on Stack Overflow - Search for 'Stack Overflow'
So a couple silly questions: If I include this in some event: MsgBox " ", vbOkOnly, "This little message box" could I then with some more code turn around and 'click the ok button. So that basically the message boox automatically pops up, and then automatically goes away? I know its silly because… >>> More
MS Access 2003 - Format a Number with Commas AND Auto-Decimal

as seen on Super User - Search for 'Super User'
On a report I have a control which is bound to a column which can have up to 3 decimal places. I want the number to format with commas separating thousands and millions, but I also want the number of decimal places to be automatic, so that if there is no decimal portion then no decimal at all is… >>> More
MS Access 2003 - VBA for altering a table after a "SELECT * INTO tblTemp FROM tblMain" statement

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I use functions like the following to make temporary tables out of crosstabs queries. Function SQL_Tester() Dim sql As String If DCount("*", "MSysObjects", "[Name]='tblTemp'") Then DoCmd.DeleteObject acTable, "tblTemp" End If sql = "SELECT * INTO tblTemp from TblMain;" Debug.Print (sql) … >>> More

Developer IT

Round up all values - Developer IT

Round up all values

ms-access-2003

Related posts about ms-access-2003

MS Access 2003 - ordering the string values for a chart not alphabetical

MS Access 2003 - Embedded Excel Spreadsheet on Access form

MS Access 2003 - Message Box: How can I answer "ok" automatically through code

MS Access 2003 - Format a Number with Commas AND Auto-Decimal

MS Access 2003 - VBA for altering a table after a "SELECT * INTO tblTemp FROM tblMain" statement

Categories cloud