What sql string has to be?

Hi all,
I try to query the record MemberID = <some number as long type>. I don't
know what symbol I have to patch to the sql string to open the DAO
recordset, can someone shed some light on this please.

Here's my sample code

when I use the single quote <'>, it give me error: 3464 datatype mismatch in
criteria expression
sql = "SELECT * FROM TblMembers WHERE MemberID = " & "'" & s & "'"
Set rs = db.OpenRecordset(sql, dbOpenDynaset)

when I use the number sign <#>, it give me error: 3075 Syntax error in date
in query expression 'MemberID = #232#'
sql = "SELECT * FROM TblMembers WHERE MemberID = " & "#" & s & "#"
Set rs = db.OpenRecordset(sql, dbOpenDynaset)

The data type defined for MemberID is LONG

Thanks for your help
Jing.

re: What sql string has to be?

"JingleBEV" <n_quan@NOSPAMyahoo.com> skrev i en meddelelse
news:7nwHc.48052$JG5.1238819@news20.bellglobal.com ...[color=blue]
> Hi all,
> I try to query the record MemberID = <some number as long type>.[/color]
I don't[color=blue]
> know what symbol I have to patch to the sql string to open the[/color]
DAO

If it's a number then don't use anything around it !

sql = "SELECT * FROM TblMembers WHERE MemberID = " & CLng(s)

or like this

sql = "SELECT * FROM TblMembers WHERE MemberID = [ID]"
sql = Replace(sql, "[ID]", CLng(s))


--
/\ preben nielsen
\/\ prel@post.tele.dk

re: What sql string has to be?

"JingleBEV" <n_quan@NOSPAMyahoo.com> wrote in message news:<7nwHc.48052$JG5.1238819@news20.bellglobal.co m>...[color=blue]
> Hi all,
> I try to query the record MemberID = <some number as long type>. I don't
> know what symbol I have to patch to the sql string to open the DAO
> recordset, can someone shed some light on this please.
>
> Here's my sample code
>
> when I use the single quote <'>, it give me error: 3464 datatype mismatch in
> criteria expression
> sql = "SELECT * FROM TblMembers WHERE MemberID = " & "'" & s & "'"
> Set rs = db.OpenRecordset(sql, dbOpenDynaset)
>
> when I use the number sign <#>, it give me error: 3075 Syntax error in date
> in query expression 'MemberID = #232#'
> sql = "SELECT * FROM TblMembers WHERE MemberID = " & "#" & s & "#"
> Set rs = db.OpenRecordset(sql, dbOpenDynaset)
>
> The data type defined for MemberID is LONG
>
> Thanks for your help
> Jing.[/color]

Don't use quotes and double check your spelling in both the code and the table:

sql = "SELECT * FROM TblMembers WHERE MemberID = " & s