Category: MS Access Functions

In Access, the Sqr function returns the square root of a number. The syntax for the Sqr function is: Sqr ( number…

In Access, the Space function returns a string consisting of the specified number of spaces. The syntax for the Space…

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

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

In Access, the Second function returns a number between 0 and 59, inclusive, representing the second of the minute of…

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

In Access, the Round function returns a number rounded to a specified number of decimal places. The syntax for the Round…

In Access, the Rnd function returns a single containing a random number. You can specify the random number to be…

In Access, the Now function returns the current date and time according your computer’s system date and time. The syntax…

In Access, the MonthName function returns a string containing the specified month. The syntax for the MonthName function is: MonthName…