Microsoft KB Archive/81751

= Works: Valid Database Functions =

Article ID: 81751

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 3.0 for MS-DOS
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q81751



SUMMARY
The following is a list of functions that you can use in the Works Database:   ABS(x) ACOS(x) ASIN(x) ATAN(x) ATAN2(x-coordinate,y-coordinate) AVG(Fieldname0,Fieldname1,...) CHOOSE(Choice,Option0,Option1,...) COS(x) COUNT(Fieldname1,Fieldname2,...) CTERM(Rate,FutureValue,PresentValue) DATE(Year,Month,Day) DAY(DateNumber) DDB(Cost,Salvage,Life,Period) ERR EXP(x) FALSE FV(Payment,Rate,Term) HOUR(TimeNumber) IF(Condition,ValueIfTrue,ValueIfFalse) INT(x) ISERR(x) ISNA(x) LN(x) LOG(x) MAX(Fieldname1,Fieldname2,...) MIN(Fieldname1,Fieldname2,...) MINUTE(TimeNumber) MOD(Numerator,Denominator) MONTH(DateNumber) NA NOW PI PMT(Principal,Rate,Term) PV(Payment,Rate,Term) RAND RATE(FutureValue,PresentValue,Term) ROUND(x,NumberOfPlaces) SECOND(TimeNumber) SIN(x) SLN(Cost,Salvage,Life) SQRT(x) SUM(Fieldname1,Fieldname2,..) SYD(Cost,Salvage,Life,Period) TAN(x) TERM(Payment,Rate,FutureValue) TIME(Hour,Minute,Second) TRUE YEAR(DateNumber) In addition, Works 3.0 and later include the following text and logical functions:   AND(logical1,logical2,...) EXACT(Textvalue1,Textvalue2) FIND(FindText,SearchText,Offset) LEFT(TextValue,Length) LENGTH(TextValue) LOWER(TextValue) MID(TextValue,Offset,Length) N(RangeReference) NOT(logical) OR(logical1,logical2,...) PROPER(TextValue) REPEAT(TextValue,Count) REPLACE(OldText,Offset,Length,NewText) RIGHT(TextValue,Length) S(RangeReference) STRING(x,DecimalPlaces) TRIM(TextValue) UPPER(TextValue) VALUE(TextValue) NOTE: There are some extra functions which can be used, but which do not normally make sense in the context of the database list or form views. These are ROWS, STD, VAR, COLS and NPV. Although you can enter these functions and get a value, in most cases the material you would want to use them on would be across records. However, you can correctly use the STD or VAR function in a database by entering it into the Summary or Summ row of a database report.

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a function

Keywords: kbinfo KB81751

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.