Using other Date/Time functions


show more Using other Date/Time functions provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth show less
please wait ...

Using other Date/Time functions

Typically, dates and times stored within your database are very specific. Dates are usually specific to a particular day and times are specific to the minute. When it comes time to query your data by month or year, Access provides a few simple ways to extract just the level of precision that you need from your Date and Time fields. Let's go to Create and we'll take a look at a new query in Design view. We'll add tbl_DirectCustomers, tbl_Orders, and tbl_Products. Let's go ahead and close Show Table. Now, let's say we want to take a look at the orders that came from specific states over a specific reporting period.

We'll add states to our query. We'll add State to our query and we'll add Price from the Products table. Let's turn on the Totals row, because we want to group everything down to the State. We could turn this Group By to a Sum to get a sum total for each state. If we run this, Access will return a list of each state listed, we have 50 represent...

Using other Date/Time functions
Video duration: 3m 47s 3h 2m Intermediate

Viewers:

Using other Date/Time functions provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth

Subject:
Business
Software:
Access
Author:
please wait ...