getting mismatch error when I try to run query

G

Guest

i am doing homework, have to use design view to create query,ok did that then
had to select salery field >35000, ok that is working, but when I try putting
in BonusQuota field value between 40And 50 I get the mismatch data error.
according to the Access comparison operators table I am suppose to type (
Between40And50 ) in the criteria box and then press enter, when I hit enter
it gets the quotation marks but i get the error when I try to hit run. In
the field size I have byte,caption is bonus quota I just can't figure whaat I
am doing wrong.
 
G

Guest

Is there a space in the criteria

Between40And50

Should be
Between 40 And 50

Also, what is the field type? And can you post the full SQL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data mismatch 2
Data mismatch error 2
i am getting the message "Type Mismatch" 1
Number to Number "Data Type Mismatch in Expression" in Join 1
Calculating Values in a Query 8
Error: Data type mismatch in criteria expression 0
DATE ERROR IN QUERY "DATA MISMATCH...ETC. 8
VBA type mismatch error - BUT the same exact query runs fine by it 7

Top