Sorting

  • Thread starter Thread starter Reen
  • Start date Start date
R

Reen

Hi,
I need to resend letters according to the date they were originally sent
out. They are all in a database under "date mailed" How do I sort them so I
get only October?
Thank you.
 
It is not a matter of 'sorting' but setting criteria.
In design view use a calculated field like this --
Mail_Month_Year: Format([date mailed], "mmyyyy")
In criteria row put --
"102009"
 
Sorting is the order that you want the records returned. Since you want just
a part of the records in the table, the proper terminology is "returned".

Also a 'database' is a collection of objects. Tables, which hold data, are a
type of object. The records you want are in a table.

A query returns records from a table. To return certain records, you need
criteria in a query. That will limit the records returned.

So create a new query based on the table holding the letter records. In the
criteria row under date field put the following:

Between #1 October 2009# and #31 October 2009# + .99999

The .99999 takes care of a small problem if there is both date and time
stored in the field.
 
Back
Top