E
etingkieng
Create the expression
1. On the Home tab, in the Sort & Filter group, click Advanced and then
click Advanced Filter/Sort on the shortcut menu.
2. Type an expression in the Field row in the first column. For example,
to sort by month regardless of the year, type the expression Expr1:
DatePart("m",[BirthDate]) in the Field row in the first column.
3. To sort records by days within each month, type Expr2:
DatePart("d",[BirthDate]) in the Field row in the second column.
The DatePart function in the first column sorts the records by month,
and the DatePart function in the second column sorts the records by days
within each month.
4. In the Sort row, select Ascending or Descending for each of the
expressions.
An ascending sort in the first column displays January at the top and
December at the bottom. An ascending sort in the second column displays 1 at
the top and 31 at the bottom. A descending sort order does the opposite.
5. On the Home tab, in the Sort & Filter group, click Toggle Filter.
I successfully do the above, but whenever i go out and add new record from
table, then come back to that query, the advanced filter lost, cant work,
cant automatically sorted ascending by month, then day of month.
Then, i found at access website that can filter onload, but it is not clear
enough. could anyone guide me?