## 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”