Category: MS Access Functions

In Access, the Fix function returns the integer portion of a number. The syntax for the Fix function is: Fix…

In Access, the Exp function returns a double specifying e raised to the nth power. The constant e is approximately…

In Access, the FileDateTime function returns the date and time when a file was created or last modified. The syntax for…

In Access, the Day function returns an integer between 1 and 31, inclusive, that represents the day of the month…

In Access, the DateValue function returns the date represented by the date of a String argument. The syntax for the DateValue…

In Access, the DateSerial function returns the date for a specific year, month, and day. The syntax for the DateSerial function…

In Access, the DatePart function returns the specified part of a given date. The syntax for the DatePart function is: DatePart (…

In Access, the DateDiff function returns the number of time intervals between two dates. The syntax for the DateDiff function is:…

In Access, the DateAdd function Adds a specified time interval to a date. The syntax for the DateAdd function is: DateAdd (…

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