In this free tip video, I'll show you how to find records between two dates using an Access query. We'll use the BETWEEN keyword and an inequality. For more on this subject, see my Access 2010 Beginner Level 5 class.

Find Records Between Two Dates and sum by multiple Upload Images   Link   Petya Pashova  6 years ago Hi Instructor Rost, I enjoy your tutorials very much and help me build my first database. But I'm having issues with one of my reports. can you help me please? I created a quiry which runs for a specific date I enter. Then I created report on this query, I added totals for the values but I also need a subtotal of a set of the records. I use the Dsum function but since the report is within certain date range, I come up with an error on the Dsum. How to fix that error? Read More... Reply from Alex Hedley: Are you adding the date condition in your dsum Can you share the code you have used? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Tip Find Records Between Two Dates Upload Images   Link   Stefanie  7 years ago Dear Rick, I created a query to return data between two dates. However, the report created from this query is asking for the start Date twice. Do you know why this is happening? Reply from Alex Hedley: Read More... Does the Query when you open that? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Tip Find Records Between Two Dates Upload Images   Link   Tony Barnett  7 years ago Those nine fields are dates of expiration for various job requirements. What I want is when I type in a beginning and ending date I want the name of the employee, plus any and all items that appear between those two dates. Read More... Reply from Alex Hedley: Add the BETWEEN criteria in each Field OR  is down so stagger then one on each line. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Show Older Comments...
View in Table Format