Access Constellation Function _ Access Query Constellation

The problem of accessing and selecting date function in query

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.