Access Level 9 Lesson 2 - Microsoft Access Beginner 9


	Back to Access Beginner 9 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Level 9 Lesson 2

Kenneth Wykoff

2 years ago

I am stuck on this lesson. I believe I had followed the instructions correctly and even looked through the handbook but when I placed this criteria into the field in the Date/Time,=>[Enter Date] And <[Enter Date]+1 and then place [Enter Date] in the Parameters area and choose Date with Time, I get nothing other than the current date. I am using Access 365 so what is going wrong?
Thanks, Ken

	Kenneth Wykoff OP @Reply 2 years ago
I figured it out. The video shows only 11/24 being typed in and then I tried typing in 11/24/12 and they all came up. Not sure why the video only showed it working with just the first to dates. Ken

	Matt Hall @Reply 2 years ago
It looks like the video was recorded in 2012. Access presumes the current year if you don't specify it.

	Kenneth Wykoff OP @Reply 2 years ago
Thanks Matt, I kind of thought it had to be something to do with that older version of Access. Ken

	Richard Rost @Reply 2 years ago
Nope... just older data. :)

	Kenneth Wykoff OP @Reply 2 years ago
Thanks Richard, will any of the future classes and levels be taught with 2019 or higher?

	Adam Schwanz @Reply 2 years ago
All of the new classes are made on the most current version of Access. Richard is going back and re-filming old courses so eventually they'll all be updated. At least until the next time he has to re-film them again in 2035 ;).

	Richard Rost @Reply 2 years ago
Yeah, as you get higher in the levels you get closer to the current version. See Office Versions for the details.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 9.

Next Unseen

New Feature: Comment Live View