You enter the expression in the Field cell in the query design grid. The fields you reference in the expression are from the tables or queries in the current query.
| Expression | Description |
|---|---|
| LagTime: DateDiff("d", [OrderDate], [ShippedDate]) | Uses the DateDiff function to display in the LagTime field the number of days between the order date and ship date. |
| YearHired: DatePart("yyyy",[HireDate]) | Uses the DatePart function to display in the YearHired field the year each employee was hired. |
| Date( )- 30 | Uses the Date function to display the date 30 days prior to the current date. |