the table from which i develop my queries has a column called "date." in it all the contributions on a particular sunday's dates are listed for all the contributors that date. the date changes every sunday w/ its attendant list of contributions/contributors.
when i develop queries, by name of contributor, every contribution for that person is listed in the simple query for the year 2003. when i sort by date using a descending or ascending sort, the list sorted by dates looks like this, for example:
(ascending sort)
1 aug 03
5 nov 03
13 aug 03
20 dec 03, etc.
31 january
this result is not what i'm trying to achieve. i would like to set up criteria that would list all the dates
for january through december 2003 in a sequential order for each month, i.e., all the january dates would be listed together in ascending or descending order, then february's dates, followed by march's, etc. until the end of december.
hope this clarifies things. tnx for your assistance.