Round Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Yields a number rounded to a defined number of decimal places. Syntax Round( expression [, numdecimalplaces ] ) The Round function syntax has these arguments: Argument Description expression Required. Numeric expression being rounded. numdecimalplaces Optional. Number indicating how many places to the right of the decimal are included in the rounding.Continue reading “Round Function”

IsNull Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Boolean value that represents whether an expression includes no valid data (Null). Syntax IsNull ( expression ) The necessary expressionargument is a Variant including a numeric expression or string expression. Remarks IsNull returns True if expression is Null; otherwise, IsNull returns False. If expression comprises several variables, Null in any constituent variable results in True to be returned for the wholeContinue reading “IsNull Function”

Nz Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. You can employ the Nz function to return zero, a zero-length string (” “), or another defined value once a Variant is Null. For example, you can use this function to convert a Null value to another value and prevent it from propagating through an expression. Syntax Nz ( variant [, valueifnull ] )Continue reading “Nz Function”

Type Conversion Functions

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Each function forces an expression to a distinct data type. Syntax CBool( expression ) CByte( expression ) CCur( expression ) CDate( expression ) CDbl( expression ) CDec( expression ) CInt( expression ) CLng( expression ) CSng( expression ) CStr( expression ) CVar( expression ) The required expressionargument is any string expression or numeric expression. Return Types The function name determines the return type as shown in theContinue reading “Type Conversion Functions”