Skip to search results
PRODUCT
Office.com results
Chr Function
Article Returns a String containing the character associated with the specified character code . Syntax Chr ( charcode ) The required charcode argument is a Lo...
Access 2007
Rate Function
Article Returns a Double specifying the interest rate per period for an annuity. Syntax Rate( nper , pmt, pv [ , fv ] [ , type ] [ , guess ] ) The Rate functi...
Access 2007
RGB Function
Article Returns a Long representing an RGB color value. Syntax RGB( red, green, blue ) The RGB function syntax has these arguments : Argument Description red Requi...
Access 2007
QBColor Function
Article Returns a Long representing the RGB color code corresponding to the specified color number. Syntax QBColor ( color ) The required color argument is a whol...
Access 2007
PV Function
Article Returns a Double specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate. Syntax PV( r...
Access 2007
Replace Function
Article Returns a String in which a specified substring has been replaced with another substring a specified number of times. Syntax Replace( expression, find, replac...
Access 2007
Atn Function
Article Returns a Double specifying the arctangent of a number. Syntax Atn ( number ) The required number argument is a Double or any valid numeric expression ...
Access 2007
Asc Function
Article Returns an Integer representing the character code corresponding to the first letter in a string. Syntax Asc ( string ) The required string argument is ...
Access 2007
NPV Function
Article Returns a Double specifying the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate. Synta...
Access 2007
MacScript Function
Article Executes an AppleScript script and returns a value returned by the script, if any. Syntax MacScript ( script ) The script argument is a string expression . T...
Access 2007
CallByName Function
Article Executes a method of an object, or sets or returns a property of an object . Syntax CallByName ( object , procname , calltype [, args ()] ) The CallByName...
Access 2007
Oct Function
Article Returns a Variant ( String ) representing the octal value of a number. Syntax Oct( number ) The required number argument is any valid numeric expression ...
Access 2007
Partition Function
Article Returns a Variant ( String ) indicating where a number occurs within a calculated series of ranges. Syntax Partition( number, start, stop, interval) The Part...
Access 2007
Minute Function
Article Returns a Variant ( Integer ) specifying a whole number between 0 and 59, inclusive, representing the minute of the hour. Syntax Minute( time ) The required ...
Access 2007
Mid Function
Article Returns a Variant ( String ) containing a specified number of characters from a string. Syntax Mid( string, start [ , length ] ) The Mid function syntax has the...
Access 2010, Access 2007
PPmt Function
Article Returns a Double specifying the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. Syntax PPmt ( ...
Access 2007
Pmt Function
Article Returns a Double specifying the payment for an annuity based on periodic, fixed payments and a fixed interest rate. Syntax Pmt( rate, nper , pv [ , fv ] [...
Access 2007
Month Function
Article Returns a Variant ( Integer ) specifying a whole number between 1 and 12, inclusive, representing the month of the year. Syntax Month( date ) The required da...
Access 2007
MIRR Function
Article Returns a Double specifying the modified internal rate of return for a series of periodic cash flows (payments and receipts). Syntax MIRR( values () , financ...
Access 2007
Nz Function
Article Syntax: Nz(variant [, valueifnull ] )
Access 2010, Access 2007
Array Function
Article Returns a Variant containing an array . Syntax Array( arglist ) The required arglist argument is a comma-delimited list of values that are assigned to th...
Access 2007
Now Function
Article Returns a Variant ( Date ) specifying the current date and time according your computer's system date and time. Syntax Now Example Note Examples that fo...
Access 2007
MonthName Function
Article Returns a string indicating the specified month. Syntax MonthName ( month [ , abbreviate ] ) The MonthName function syntax has these arguments: Argument De...
Access 2007
NPer Function
Article Returns a Double specifying the number of periods for an annuity based on periodic, fixed payments and a fixed interest rate. Syntax NPer ( rate, pmt, pv [ ...
Access 2007
Choose Function
Article Selects and returns a value from a list of arguments . Syntax Choose( index , choice-1 [, choice-2 ] ... [, choice-n ] ) The Choose function syntax has ...
Access 2007
Didn't find what you were looking for?Search all of Office.com