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 WykoffOP
@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 WykoffOP
@Reply 2 years ago
Thanks Matt, I kind of thought it had to be something to do with that older version of Access. Ken
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 ;).
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 9.
