In lesson 2 at 8:30, I am getting the error The expression is typed incorrectly or is too complex to be evaluated even after I enter the explicit query parameter.
My explicit query parameter is: [Enter Date] My explicit query parameter data type is: Date With Time My Query criteria is: >=[Enter Date] And <[Enter Date] + "1" My Access version: 365 Note: The quotation marks around my "1" are involuntarily added by Access. This is different from Richard's video. Does this treat the 1 as a string instead of a number?
Any suggestions?
Kevin Robertson
@Reply 3 years ago
Check the Data Type of DateTime. Sounds like you've made it a Short Text field instead of Date/Time
Scott Axton
@Reply 3 years ago
Make sure the data type is Date. By default is comes in as short text.
Scott Axton
@Reply 3 years ago
Kevin you are too darn fast!
Todd AdamsOP
@Reply 3 years ago
Perfect .. Thank you so much Kevin. I had it wrong in my table. Gotta love 'operator error.'
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
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.
