Data type mismatch in criteria expression.

10-29-2006, 04:34 PM

MTBPatriot MTBPatriot is offline

Newcomer

Join Date: Oct 2006

Posts: 1

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.

10-29-2006, 09:22 PM

loquin

Google Hound

Retired Moderator
* Guru *

Join Date: Nov 2001

Location: Arizona, USA

Posts: 12,378

what is the field type of Parent?

__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules