Access Level 9 Lesson 2 - Microsoft Access Beginner 9


	Back to Access Beginner 9 Comments List

Upload Images Link Email

Access Level 9 Lesson 2

Kenneth Wykoff

11 months 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 11 months 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 11 months ago
It looks like the video was recorded in 2012. Access presumes the current year if you don't specify it.

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

	Richard Rost 11 months ago
Nope... just older data. :)

	Kenneth Wykoff OP 11 months ago
Thanks Richard, will any of the future classes and levels be taught with 2019 or higher?

	Adam Schwanz 11 months 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 11 months 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.