Error in simple query when I use variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prince - 11 Sep 2006 16:55 GMT

Please see below query when I use any digit instead of X it works but X is
not working:

Set Rs = Db.OpenRecordset("SELECT DetailPicknote.DTime,
DetailPicknote.DDate, DetailPicknote.DetailID FROM DetailPicknote WHERE
DetailPicknote.DetailID = x")

Reply to this Message

Douglas J. Steele - 11 Sep 2006 17:02 GMT

Set Rs = Db.OpenRecordset("SELECT DetailPicknote.DTime,
DetailPicknote.DDate, DetailPicknote.DetailID FROM DetailPicknote WHERE
DetailPicknote.DetailID = " & x)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Please see below query when I use any digit instead of X it works but X is
> not working:
>
> Set Rs = Db.OpenRecordset("SELECT DetailPicknote.DTime,
> DetailPicknote.DDate, DetailPicknote.DetailID FROM DetailPicknote WHERE
> DetailPicknote.DetailID = x")

Reply to this Message