This Microsoft Access video tutorial picks up where Level 4 left off. This class covers query criteria in a lot more depth, parameter queries, wildcards, and lots more. Topics include:

- Query Criteria
- Multiple AND, OR Conditions
- Inequalities
- Records Between Two Dates
- Dealing with Null Values
- Wildcards and LIKE
- Parameter Queries
- Top X Values
- Formatting Query Field Output

Click here for more information on Access 2010 Beginner Level 5, including a course outline, sample videos, and more.

Criteria Between Two Times Link  Andrew Cleary       4 days ago I want to filter out any dates and times More than 7 AM each day.   Example I want to show a date and time 1/21/2021 03:00 but I do not want to show a date that happens 1/21/2021 09:00.   as of right now I have to go in each day and replace my criteria so it says =#1/21/2021 06:59:00 AM# I want the query to know that update the calendar day and keep the time the same. Alex Hedley          4 days ago The DateValue covered in Expert 28 chops the time portion off a date and leaves you just that. So you could use that on your date input. Then its just a matter of adding the time. Since dates are stored in access as 1 you just need a portion of that so 7/24. Andrew Cleary      3 days ago I figured out how to use a text box as the criteria in all my queries so the end user can use the date picker to customize the date and time of the filter for the reports.  I will probably end up taking that class as it has a lot of info on what I am currently working on.  Thanks! Richard Rost         3 days ago Hour(MyDateTime)<=7 Andrew Cleary      2 days ago Thanks Richard, I'll try this when I get back to work in a couple of weeks. 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 All Comments