ACCESS query expression that works on one computer but not another

[heavenlyhost1]

On my flash drive I have an expression in an ACCESS query like: Between
[Enter Beginning Date ex: 1-1-09] And [Enter Ending Date ex: 1-31-09]. It
works great, but when I copied the query to my desktop, I get this error:
"This expression is typed incorrectly, or it is too complex to be evaluated."
Why would the expression work from my flash drive and not when I paste it to
my database on my desktop?

 

[KARL DEWEY]

Is the desktop field being evaluated text or DateTime?

 

[John W. Vinson]

On my flash drive I have an expression in an ACCESS query like: Between
[Enter Beginning Date ex: 1-1-09] And [Enter Ending Date ex: 1-31-09]. It
works great, but when I copied the query to my desktop, I get this error:
"This expression is typed incorrectly, or it is too complex to be evaluated."
Why would the expression work from my flash drive and not when I paste it to
my database on my desktop?

Try defining the query Parameters. Open the query in design view, and
rightclick the grey background of the tables; choose Parameters.

Copy and paste your parameters - [Enter Beginning Date ex: 1-1-09] for example
- into the left column of the grid (they must match exactly); define them as
DateTime using the dropdown in the right. This will ensure that Access treats
the user entry as a date, rather than some sort of division calculation.

 

[heavenlyhost1]

You were exactly right. The date fields were still in text format in the mdb
table on my desktop. Once I changed them to a date field, the criteria
worked perfectly. Thank you.

Is the desktop field being evaluated text or DateTime?
--
KARL DEWEY
Build a little - Test a little

On my flash drive I have an expression in an ACCESS query like: Between
[Enter Beginning Date ex: 1-1-09] And [Enter Ending Date ex: 1-31-09]. It
works great, but when I copied the query to my desktop, I get this error:
"This expression is typed incorrectly, or it is too complex to be evaluated."
Why would the expression work from my flash drive and not when I paste it to
my database on my desktop?

 

[heavenlyhost1]

Thank you for taking the time to respond to my issue. It has been fixed now.
I do appreciate your help.

On my flash drive I have an expression in an ACCESS query like: Between
[Enter Beginning Date ex: 1-1-09] And [Enter Ending Date ex: 1-31-09]. It
works great, but when I copied the query to my desktop, I get this error:
"This expression is typed incorrectly, or it is too complex to be evaluated."
Why would the expression work from my flash drive and not when I paste it to
my database on my desktop?

Try defining the query Parameters. Open the query in design view, and
rightclick the grey background of the tables; choose Parameters.

Copy and paste your parameters - [Enter Beginning Date ex: 1-1-09] for example
- into the left column of the grid (they must match exactly); define them as
DateTime using the dropdown in the right. This will ensure that Access treats
the user entry as a date, rather than some sort of division calculation.