MTBPatriot
Joined: 28 Oct 2006
Posts: 1
|
 Posted: Mon Oct 30, 2006 12:35 am Post subject: Data type mismatch in criteria expression. |
 |
|
I'm trying to retrieve information from a Microsoft Access database where the field "PARENT" is equal to a certain variable, but I keep getting a Data Type Mismatch.
Heres the SQL:
| Code: |
| rsRecordSet.Source = "SELECT * FROM " & which_table & " WHERE PARENT = " & whichtest |
When its running, rsRecordSet.Source is:
| Code: |
| SELECT * FROM Questions WHERE PARENT = 2 |
The error I keep getting is:
Data type mismatch in criteria expression.
I really have no idea on how to continue from here.
Thanks in advance for any advice you guys can give! |
|
