Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

Working with Dates in Criteria

Access gives you significant power for adding date functions and expressions to your query criteria. Using these criteria, you can find all records in a certain month, on a specific weekday, or between two dates. Table 4.2 lists several examples.

Table 4.2. Sample Date Criteria

The Weekday(Date, [FirstDayOfWeek]) function works based on your locale and how your system defines the first day of the week. Weekday() used without the optional FirstDayOfWeek argument defaults to vbSunday as the first day. A value of 0 defaults the FirstDayOfWeek to the system definition. Other values can be set also.

Figure 4.9 illustrates the use of a date function. Notice that DatePart("q",[OrderDate]) is entered as the expression, and the value of 2 is entered for the criteria. Year([OrderDate)] is entered as another expression with the number 1997 as the criteria. Therefore, this query outputs all records in which the order date is in the second quarter of 1997.