H
Haggr via AccessMonster.com
Criteria: how to search data [date] by every month for every year?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
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.
H
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.