Tổng quan SQL_ Visual Basic Function Reference

Finding all the most useful functions in Help can be difficult at best. When you know the function name you want, you can type it in the Visual Basic Editor, highlight the name, and then press F1 to go directly to the help topic. Following is a list of functions, categorized by type, that you might need to use. The tables list the function name and a brief description of what the function does. You can easily find details about the particular function syntax in Help once you know the function name....
Nội dung trích xuất từ tài liệu:
Tổng quan SQL_ Visual Basic Function Reference Part 9: Articles Article 3Visual Basic FunctionReference Finding all the most useful functions in Help can be difficult at best. When you know the function name you want, you can type it in the Visual Basic Editor, highlight the name, and then press F1 to go directly to the help topic. Following is a list of functions, categorized by type, that you might need to use. The tables list the function name and a brief description of what the function does. You can easily find details about the particular function syntax in Help once you know the function name. As you know, you can call most Visual Basic functions from queries that you create in an Access desktop database (.mdb). If you convert your application to SQL Server, you need to know the equivalent function or clause you can use to obtain the same result. The tables also list the SQL Server equivalent for all function types except User Interface/File System Functions. Table A3-1. Arithmetic Functions Name Description SQL Server Equivalent Abs Returns the absolute value of a number. ABS Asc Returns the integer value of a character. ASCII Atn Returns the arctangent of a number. ATAN Cos Returns the cosine of a number that is an COS angle specified in radians. DDB Returns a double value containing the depreciation (none) of a value for a specific time period. Exp Returns the value of the base of the natural EXP logarithm (e) raised to the exponent you supply. See also Log. Fix Returns the value of the number you supply CAST, CONVERT (to truncated to an integer. If the number is tinyint, smallint, int, negative, Fix returns the first integer that or bigint) is greater than or equal to the number. See also Int. FV Calculates the future value of an annuity. (none) A49 Part 9: ArticlesPart 9: Articles Microsoft Office Access 2003 Inside Out Table A3-1. Arithmetic FunctionsChapter A3 Name Description SQL Server Equivalent Int Returns the value of the number you supply trun- FLOOR cated to an integer. If the number is negative, Int returns the first integer that is less than or equal to the number. See also Fix. IPmt Returns the interest payment for a given period (none) of an annuity.Chapter A3 IRR Returns the internal rate of return for a series of (none) periodic cash flows. LBound Returns the lowest available subscript for the (none) array and dimension you specify. See also UBound. Log Returns the natural logarithm of the number you LOG supply. See also Exp. MIRR Returns the modified internal rate of return for (none)Article 3 a series of periodic cash flows. NPer Returns the number of payment periods for (none) an annuity. NPV Returns the net present value of an investment. (none) Pmt Returns the payment required for an annuity. (none) PPmt Returns the amount applied to principal for a (none)Chapter A3 given payment period of an annuity. PV Returns the present value of an annuity. (none) Rate Returns the interest rate of an annuity. (none) Rnd Returns a random number. RAND Round Rounds a number to the specified number of ROUND ...