Category: MS Access Functions

In Access, the Year function returns an integer between 100 and 9999, inclusive, that represents the year of a date…

In Access, the WeekdayName function returns the name of the day of the week corresponding to the date and the…

In Access, the Weekday function returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the…

In Access, the Val function returns a variant indicating the sign of a number. The syntax for the Val function is:…

In Access, the Trim function returns a copy of a string with leading and trailing spaces removed. The syntax for…

In Access, the TimeValue function returns the time represented by a string argument. The syntax for the TimeValue function is: TimeValue (…

In Access, the TimeSerial function returns the time for a specific hour, minute, and second. The syntax for the TimeSerial function…

In Access, the Time function returns the current system time. The syntax for the Time function is: Time ( ) The Time function…

In Access, the Tan function returns the tangent of an angle. The syntax for the Tan function is: Tan ( number )…

In Access, the Str function returns string representation of a number. The syntax for the Str function is: Str( number…