Microsoft Office Tutorials and References
In Depth Information
Date arithmetic in a query
Assume that you set the format of the Bonus field to Currency. The output will be similar to that in
Figure B-35, although your Bonus data will be different because you used a different date.
Output of query with date arithmetic
Using Time Arithmetic in Queries
Access also allows you to subtract the values of time fields to get an elapsed time. Assume that your database
has a Job Assignments table showing the times that nonsalaried employees were at work during a day. The
definition is shown in Figure B-36.
Date/Time data definition in the Job Assignments table
Assume that the DateWorked field is formatted for Long Date and that the ClockIn and ClockOut fields
are formatted for Medium Time. Also assume that for a particular day, nonsalaried workers were scheduled as
shown in Figure B-37.
Display of date and time in a table