Query error

H

h3llz

Datatype mismatch (productID is number, deleted is Yes/No)

"SELECT * FROM tblBasketContent WHERE productID=" & productID & " AND
deleted=No;"
 

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

Error with form.requery (no current record) 3
Unable to display values in 2nd list box from 1st list box selection 2
Append querie error 4
VB Error 2
Append queries... 1
What is wrong with this? 4
Runtime error 3008 1
Different RowSource for a Combo Box in a Datasheet for each row? 1

Top