Microsoft KB Archive/22748

= Microsoft Knowledge Base =

File: Finding Records Between Two Values or Dates
Last reviewed: October 26, 1994

Article ID: Q22748

Summary:

In Microsoft File, specifying a range of data to find in a field is done by using elipses. Under the Organize menu in the Find dialog box, a beginning and ending value should be entered into a field box with three periods between the values. Three periods (elipses) are equivalent to saying, "Find all records where the data in the 'Find' field is greater than the beginning value AND less than the ending value." For example, "1/15/87...4/23/87" would find all records between January 15, 1987, and April 23, 1987.

Please note that finding dates requires the use of the "mm/dd/yy" numeric date format.