Search By Month

[Haggr via AccessMonster.com]

Criteria: how to search data [date] by every month for every year?

 

[fredg]

Criteria: how to search data [date] by every month for every year?

Do you wish, for example, to get all May records for all the years, or
just May for one specific year?


For all May records in the table, add a new column to the query.
CriteriaColumn:Month([DateField])
As criteria for this column, write:
[Enter Month number]
Enter 5 when prompted for all May records of all years.

To get May records for just one year, add a new column.
CriteriaColumn:Format([DateField],"m/yyyy")
As criteria on this column, write
[Enter month and year m/yyyy]
Enter 5/2006 when prompted for May, 2006 records.

 

[Haggr via AccessMonster.com]

Need to see records sorted my month for each year in decesending order

Criteria: how to search data [date] by every month for every year?

Do you wish, for example, to get all May records for all the years, or
just May for one specific year?

For all May records in the table, add a new column to the query.
CriteriaColumn:Month([DateField])
As criteria for this column, write:
[Enter Month number]
Enter 5 when prompted for all May records of all years.

To get May records for just one year, add a new column.
CriteriaColumn:Format([DateField],"m/yyyy")
As criteria on this column, write
[Enter month and year m/yyyy]
Enter 5/2006 when prompted for May, 2006 records.