Join Adam Wilbert for an in-depth discussion in this video Defining today's date, part of Access 2010: Queries in Depth.
So far, we've taken a look at how to work with dates relative to each other or…relative to a specific and static date range.…Access provides a couple of additional functions that will allow us to define…dates relative to today or relative to right now.…These are the queries that require a date range such as within the last 30 days…or 2 weeks from today.…The first part requires us to accurately define today's date.…In the next movie, we'll take a look at how we can combine this with some…additional functions to perform some calculations to define time span.…Let's start a new query in Design view.…
Create, Query Design, and I'll add our Orders table.…Go ahead and say Close.…Instead of building an actual query, I'll use the fields here to demonstrate the…Date, Time, and Now functions.…The Date function is written like this, Date().…This tells Access to fetch the current date.…In the next field I'll write out Time followed by an open and…closing parentheses.…This tells Access to fetch the current time.…
- Naming conventions and best practices
- Working with joins
- Using comparison operators
- Defining criteria for select queries
- Creating parameter queries
- Creating calculated fields
- Working with dates and times
- Using the Expression Builder
- Creating conditional statements
- Making, deleting and appending records
- Building reports
Skill Level Intermediate
Access 2010 Power Shortcutswith Alicia Katz Pollock3h 43m Intermediate
1. Creating Queries in Access
2. Creating Simple Select Queries
3. Creating Parameter Queries
Creating a combo box4m 30s
4. Applying Aggregate Calculations (aka Totals Queries)
5. Working with Dates in Queries
6. Understanding Conditional Statements
7. Linking It All Together
8. Alternative Query Types
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.