SQL For Next

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
DoCmd.RunSQL "SELECT [ITNBR] into tbl1 FROM [SHANE_TRANSDATA] WHERE
[UPDDT]=" & X
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't update using docmd.runsql 0
Using variables as table names in an append sql statemnt 1
How-to extract data in this format? 4
Is Access SQL FROM Clause different from MS SQL Server SQL? 1
query 1
For Next with negative step ? 5
Access 2002 SQL Problem 1
SQL String variable within another String Variable 1

Back
Top