Loops in SQL

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I'm in SQL View of Access 2002 trying to create a loop for
calculated fields. Can you use SET for local counter
variables and WHILE/END.

Is there a good SQL Primer for Access 2002?
 
Hi,



In Jet, no. You have to use VBA, if you can't really do in without
"looping".


In MS SQL Server, you can use T-SQL inside a stored procedure, which
allow you to execute a sequence of statements, with some control on the flow
of execution. But T-SQL is far from a general programming language.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top