Hello! I am building a query with parameters. The query parameters are to come from the form. The form is ready, however, after entering the Criteria and running the query, an error appears: Incorrect data type in the criterion expression Code: I am asking for a hint what is wrong. Let me add...

And in which Access or SQL expressions can be used Between whether and :D Are the relevant fields in the form also properly formatted or masked (with a typing pattern)?

The code obviously has 'Between' and 'and'. Cells are formatted without an input mask.

Error: Incorrect Data Type in Access Query Criteria Expression

| New topic

#1 16692241 10 Sep 2017 17:50

gnat1985 gnat1985

Level 2

» |

Post #1
16692241 10 Sep 2017 17:50

Hello!
I am building a query with parameters. The query parameters are to come from the form.
The form is ready, however, after entering the Criteria and running the query, an error appears: "Incorrect data type in the criterion expression"

Code:

Code: SQL
Log in, to see the code

I am asking for a hint what is wrong. Let me add that all date formats are the same: short date.
ADVERTISEMENT
Helpful post

#2 16692450 10 Sep 2017 21:12

Prot Prot

Level 38

» | Helpful post? (+1)

Helpful post
Post #2
16692450 10 Sep 2017 21:12

gnat1985 wrote:
" Between [forms] [Report form]! [Date from] and [forms]! [Report form]! [Date to]"

And in which Access or SQL expressions can be used Between whether and :D

Are the relevant fields in the form also properly formatted or masked (with a typing pattern)?
#3 16692851 11 Sep 2017 07:40

gnat1985 gnat1985

Level 2

» | Topic author Helpful post? (0)

Post #3
16692851 11 Sep 2017 07:40

The code obviously has 'Between' and 'and'. Cells are formatted without an input mask.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

| New topic

Report a violation of the law

Error: Incorrect Data Type in Access Query Criteria Expression - Form Parameters Issue

Didn't find an answer? Ask Artificial Intelligence