Please help! Data type mismatch in criteria expression.

[blackburnj55]

Hi,

I am constructing a website for a bike shop. I am using dreamweaver and an access database to create it.

I have made a query where two criteria are entered to get results. These are : Category and price(RRP).

Here is the SQL:

"SELECT Category, Description, Image, ProductRef, RRP, SalePrice FROM BOM WHERE Category = '" + Replace(Recordset1__MMColParam, "'", "''") + "' AND RRP < '" + Replace(Recordset1__MMColParam2, "'", "''") + "'"

I get the following error:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

First of all is my code correct?
What does this error mean?

When I use simply one search criteria i have no problems. it only occurs with the two search criteria query.

any help greatly appreciated, pulling out hair!

[pks00]

Is RRP numeric or string?
If numeric then remove the single quotes

"SELECT Category, Description, Image, ProductRef, RRP, SalePrice FROM BOM WHERE Category = '" + Replace(Recordset1__MMColParam, "'", "''") + "' AND RRP < " + Replace(Recordset1__MMColParam2, "'", "''")


What datatype is Category

[blackburnj55]

thank you so much i cracked it! so simple in the end!

many thanks once more.

James

[pks00]

:)

no probs

[manishpanwar]

type missmatch is also removed by changinging number datatype to text data type bcz text datatype contain both text and number.

thanks

[NeoPa]

While that may be true at a very basic level, it is certainly not a solution to the problem of how to ensure the SQL correctly matches the type of the existing data.

See post #2 for where the correct answer has already been supplied.