《ACCESS表达式生成器》由会员分享,可在线阅读,更多相关《ACCESS表达式生成器(17页珍藏版)》请在金锄头文库上搜索。
1、 300“ 100 Or 100 ”100“Like ”“Like”“?”“*”“#”“”“!”Like “?“”“”Like “*“”“”“”Like “1”“2”Like “”“”“”Like “!“”“”“”Asc(Asc(Asc(Asc() ) ) )IntegerAsc(“A“)65 Asc(“a“)97 Asc(“Apple“)65Chr(Chr(Chr(Chr() ) ) )Chr031ASCII0 255ChrBStringChrBChrWUnicodeStringUnicodeChrChr(65)AChr(97)aDAvgDAvgDAvgDAvg ( ( ( (, , , ,
2、) ) ) )DAvg()“”“”DCount(DCount(DCount(DCount(, , , ,) ) ) )DCount ()“”“”DLookup(DLookup(DLookup(DLookup(, , , ,) ) ) )DLookup ()“”“”DMin(DMin(DMin(DMin(, , , ,) ) ) )DMax(DMax(DMax(DMax(, , , ,) ) ) )DMinDMax)DMin()“”“”DSum(DSum(DSum(DSum(, , , ,) ) ) )DMin()“”“”DVar(DVar(DVar(DVar(, , , ,) ) ) ) DV
3、arP(DVarP(DVarP(DVarP(, , , ,DVarpDVarDVarDVarPNullexprSQLDDB(cost,DDB(cost,DDB(cost,DDB(cost, salvage,salvage,salvage,salvage, life,life,life,life, period,period,period,period, factor)factor)factor)factor)costDoublesalvageDouble.lifeDoubleperiodDoublefactorVariant2FV(rate,FV(rate,FV(rate,FV(rate, n
4、per,nper,nper,nper, pmt,pmt,pmt,pmt, pv,pv,pv,pv, type)type)type)type)DoublerateDouble(APR)0.1/120.0083nperInteger4 * 1248pmtDoublepvVariant0typeVariant010ratenperratenper010ratenperratenperIRR(values(),IRR(values(),IRR(values(),IRR(values(), guess)guess)guess)guess)Doublevalues()DoubleGuessVariantI
5、RRguess0.1 (10%)IRRIRRguessIRR0.00001%20IRRMIRR(values(),MIRR(values(),MIRR(values(),MIRR(values(), finance_rate,finance_rate,finance_rate,finance_rate, reinvest_rate)reinvest_rate)reinvest_rate)reinvest_rate)Doublevalues()Doublefinance_rateDoublereinvest_rateDoubleMIRR(finance_rate)(reinvest_rate)f
6、inance_ratereinvest_rate0.12MIRRNPer(rate,NPer(rate,NPer(rate,NPer(rate, pmt,pmt,pmt,pmt, pv,pv,pv,pv, fv,fv,fv,fv, type)type)type)type)DoublerateDouble(APR)0.1/120.0083pmtDoublepvDoublefvVariant01850000500000typeVariant010NPV(rate,NPV(rate,NPV(rate,NPV(rate, values()values()values()values()Doublera
7、teDoublevalues()DoubleNPVNPVNPVvalues()NPVPVPVNPVPVPmt(rate,Pmt(rate,Pmt(rate,Pmt(rate, nper,nper,nper,nper, pv,pv,pv,pv, fv,fv,fv,fv, type)type)type)type)DoublerateDouble(APR)0.1/120.0083nperInteger4 * 1248pvDoublefvVariant01850000500000typeVariant010ratenperratenperPPmt(rate,PPmt(rate,PPmt(rate,PP
8、mt(rate,per,per,per,per,nper,nper,nper,nper, pv,pv,pv,pv, fv,fv,fv,fv, type)type)type)type)rateDouble(APR)0.1/120.0083perIntegernper1nperInteger4 * 1248pvDoublefvVariant01850000500000typeVariant010ratenperratenper0ratenperratenperRate(nper,Rate(nper,Rate(nper,Rate(nper, pmt,pmt,pmt,pmt, pv,pv,pv,pv,
9、 fv,fv,fv,fv, type,type,type,type, guess)guess)guess)guess)DoublenperDouble4 * 1248pmtDoublepvDoublefvVariant01850000500000typeVariant010guessVariantRateguess0.1 (10%)RateguessRate0.00001%20Rate10%Rateguess.SLN(cost,SLN(cost,SLN(cost,SLN(cost, salvage,salvage,salvage,salvage, life)life)life)life)DoublecostDoublesalvageDoublelifeDoublelifeSYD(cost,SYD(cost,SYD(cost,SYD(cost, salvage,salvage,salvage,salvage, life,life,life,life, period)period)period)period)DoublecostDoublesalvageDoublelifeDoubleperiodDoublelifeperiodlifeperiod