Article ID: 81751 - Last Review: November 16, 2006 - Revision: 3.1

Works: Valid Database Functions

This article was previously published under Q81751
Expand all | Collapse all

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.

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
Keywords: 
kbinfo KB81751
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
 

Article Translations

 

Related Support Centers