Access Topics: Functions (Alphabetical)

Below is a list of the most commonly used functions in Access. These functions can generally be used in either VBA code or SQL/Queries.

Alphabetical Listing of Functions:
	Abs	Day	Max
	Asc	DCount	Mid
	Atn	DFirst	Min
	Avg	Dir	Minute
	Case	DLast	MkDir
	CBool	DLookup	Month
	CByte	DMax	MonthName
	CCur	DMin	Now
	CDate	DSum	Nz
	CDbl	Exp	Replace
	CDec	FileDateTime	Right
	ChDir	FileLen	Rnd (random number)
	ChDrive	First	Round
	Choose	Format (with Dates)	RTrim
	Chr	Format (with Numbers)	Second
	CInt	Format (with Strings)	SetAttr
	CLng	Fix	Sgn
	Concat with &	GetAttr	Space
	Cos	Hour	Str
	Count	iif	StrConv
	CSng	IF-THEN-ELSE	Sum
	CStr	Instr	Switch
	CurDir	InstrRev	Time
	CurrentUser	Int	TimeSerial
	CVar	IsDate	TimeValue
	Date	IsNull	Trim
	DateAdd	IsNumeric	UCase
	DateDiff	Last	Val
	DatePart	LCase	Weekday
	DateSerial	Left	WeekdayName
	DateValue	Len	Year
	DAvg	LTrim

Miscellaneous Functions:
	Test a string for an alphanumeric value
	Convert currency into words
	Creating a custom round function
	Retrieve the user name from Windows while in an Access database