此浏览器不再受支持。
请升级到 Microsoft Edge 以使用最新的功能、安全更新和技术支持。
The following list contains topics that describe common functions used in Microsoft Access expressions.
CreateObject Function
GetObject Function
Command Function
Shell Function
Array Function
Filter Function
Join Function
LBound Function
Split Function
UBound Function
Asc Function
CBool Function
CByte Function
CCur Function
CDate Function
CDbl Function
CDec Function
Chr Function
CInt Function
CLng Function
CSng Function
CStr Function
CVar Function
Day Function
EuroConvert Method
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
GUIDFromString Method
Hex Function
Nz Method
Oct Function
Str Function
StringFromGUID Method
Type Conversion Functions
Val Function
CurrentUser Method
DDEInitiate Method
DDERequest Method
Eval Method
HyperlinkPart Method
Partition Function
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Hour Function
Minute Function
Month Function
MonthName Function
Now Function
Second Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
Weekday Function
WeekdayName Function
Year Function
DAvg Function
DCount Method
DFirst Method
DLast Method
DLookup Method
DMax Method
DMin Method
DStDev Method
DStDevP Method
DSum Method
DVar Method
DVarP Method
CVErr Function
Error Function
IsError Function
EOF Function
FreeFile Function
Input Function
Loc Function
LOF Function
Seek Function
CurDir Function
Dir Function
FileAttr Function
FileDateTime Function
FileLen Function
GetAttr Function
DDB Function
FV Function
IPmt Function
IRR Function
MIRR Function
NPer Function
NPV Function
Pmt Function
PPmt Function
PV Function
Rate Function
SLN Function
SYD Function
Environ Function
GetAllSettings Function
GetSetting Function
IsArray Function
IsDate Function
IsEmpty Function
IsMissing Function
IsNull Function
IsNumeric Function
IsObject Function
TypeName Function
VarType Function
Abs Function
Atn Function
Cos Function
Exp Function
Fix Function
Int Function
Log Function
Rnd Function
Round Function
Sgn Function
Sin Function
Sqr Function
StDev Function
StDevP Function
Tan Function
InputBox Function
MsgBox Function
CallByName Function
IMEStatus Function
QBColor Function
RGB Function
Spc Function
Tab Function
Choose Function
DoEvents Function
IIf Function
Switch Function
Avg Function
Count Function
Max Function
Min Function
Sum Function
Var Function
VarP Function
Format Function
HtmlEncode Method
InStr Function
InStrRev Function
LCase Function
Left Function
Len Function
LTrim Function
Mid Function
PlainText Method
Replace Function
Right Function
RTrim Function
Space Function
StrComp Function
StrConv Function
String Function
StrReverse Function
Trim Function
UCase Function