format string in MSAccess

I recently trained some users in how to use the Format function in Microsoft Access. They wanted a definitive list of what the format strings could be. So it's probably not possible to document every single combination, however the new Microsoft Access 2007 online help does document a large number of really useful types. Go to Microsoft Office help Online

http://office.microsoft.com/client/helppreview.aspx?AssetID=HV012026591033&ns=MSACCESS.DEV&lcid=3081&QueryID=gRnDnXje30&respos=1

Here is an excerpt.

Returns a Variant (String) containing an expression formatted according to instructions contained in a format expression.

Syntax

Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

The Format function syntax has these parts:

q
Display the quarter of the year as a number (1 – 4).