Explicit query parameter error - Microsoft Access Beginner 9


	Back to Access Beginner 9 Comments List

Upload Images Link Email

Explicit query parameter error

Todd Adams

2 years ago

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 2 years ago
Check the Data Type of DateTime. Sounds like you've made it a Short Text field instead of Date/Time

	Scott Axton 2 years ago
Make sure the data type is Date. By default is comes in as short text.

	Scott Axton 2 years ago
Kevin you are too darn fast!

	Todd Adams OP 2 years ago
Perfect .. Thank you so much Kevin. I had it wrong in my table. Gotta love 'operator error.'

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