Search By Month

  • Thread starter Thread starter Haggr via AccessMonster.com
  • Start date Start date
H

Haggr via AccessMonster.com

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

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.
 
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?
Click to expand...

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.
Click to expand...
 
Back
Top