DateDiff Function

In Access, the DateDiff function returns the difference between two date values, based on the interval specified.
The syntax for the DateDiff function is:

DateDiff ( interval, date1, date2, [firstdayofweek], [firstweekofyear])

interval is the interval of time to use to calculate the difference between date1 and date2. Below is a list of valid interval values.

Convert currency into words

Question: In Access, how can I convert currency to words?
For example,

$100 should read as "one hundred exactly"

Answer: To convert currency into words, you'll need to open your Access database and create a new module.

Generate a random number between 2 user-specified values

In Access, the Rnd function allows you to generate a random number (integer value). You can specify the random number to be a value between 2 user-specified numbers.
The syntax for the Rnd function is:

Int ((upperbound - lowerbound + 1) * Rnd + lowerbound)

upperbound is the highest value that the random number can be.
lowerbound is the lowest value that the random number can be.

Capitalize each word in a string (similar to InitCap in Oracle)

In Access, the StrConv function returns a string converted as specified.
The syntax for the StrConv function is:

StrConv ( text, conversion, LCID )

text is the string that you wish to convert.