SQL For Next

S

SLeach

Could someone help me identify my error in the following SQL statement:

Public Sub DailyRun()
For x = 1 To 2
DoCmd.RunSQL "SELECT [ITNBR] into tbl1 FROM [SHANE_TRANSDATA] WHERE [UPDDT]=
X;"
Next x
End Sub

I am wanting to output ITNBR (item #) where the UPDDT (date) equals the
variable x. Please help. Thanks! Feel free to add comments, if you like.
 
B

Brendan Reynolds

DoCmd.RunSQL "SELECT [ITNBR] into tbl1 FROM [SHANE_TRANSDATA] WHERE
[UPDDT]=" & X
 
S

SLeach

Thanks, Brendan. That did it!

Brendan Reynolds said:
DoCmd.RunSQL "SELECT [ITNBR] into tbl1 FROM [SHANE_TRANSDATA] WHERE
[UPDDT]=" & X

--
Brendan Reynolds (MVP)


SLeach said:
Could someone help me identify my error in the following SQL statement:

Public Sub DailyRun()
For x = 1 To 2
DoCmd.RunSQL "SELECT [ITNBR] into tbl1 FROM [SHANE_TRANSDATA] WHERE
[UPDDT]=
X;"
Next x
End Sub

I am wanting to output ITNBR (item #) where the UPDDT (date) equals the
variable x. Please help. Thanks! Feel free to add comments, if you
like.
Click to expand...
Click to expand...
 
Top