1, explain
Year (#2008- 12-20#)? ：
2008- 12-20 is a date value, so in ACCESS, you usually need to add a # sign on both sides of the date;
YEAR is the year of the return date #2008- 12-20#; This is 2008;
2. How to use him:
For example, you have a table with many dates, and the customer asks to calculate the total for a certain year; You can use it here, as follows:
Choice? Date field, total from? Table?
Where is it? Year ('date field') =2008
Group? By who? The date field here is the sum of the total amount in 2008.