Weekday Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Integer) containing a whole number representing the day of the week. Syntax Weekday( date [, firstdayofweek ] ) The Weekday function syntax has these arguments: Argument Description date Required. Variant, numeric expression, string expression, or any combination of these that can represent a date. If date contains Null, Null is returned. firstdayofweek Optional. AContinue reading “Weekday Function”

Replace Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a String in which a specified substring has been replaced with another substring a specified number of times. Syntax Replace( expression, find, replace [, start ] [, count ] [, compare ] ) The Replace function syntax has these arguments: Argument Description expression Required. String expression containing substring to replace. find Required. SubstringContinue reading “Replace Function”

InStr Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Long) specifying the position of the first occurrence of one string within another. See some examples Syntax InStr ([start, ] string1, string2 [, compare ] ) The InStr function syntax has these arguments: Argument Description start Optional. Numeric expression that sets the starting position for each search. If omitted, search beginsContinue reading “InStr Function”