Queries with loops and variables (query vs. vba)

[AJ]

Again, I am new to access but was wondering about queries versus going to
VBA. I have a sql server script (containing some loops and if statements)
that I would like to run after the user enters information into a form. Does
access queries allow you to do loops with variables, etc or is that when you
need to start using VBA.
Is there someone to find a tutorial on access queries that is more advanced
then the normal select, insert, update or delete.

Any information would be great.
Thanks,
AJ

 

[Tom van Stiphout]

On Tue, 13 Nov 2007 19:24:00 -0800, AJ <[email protected]>
wrote:

Access queries are a single statement. No loops etc.

Describe the problem you're trying to solve; perhaps we can suggest
some options.

-Tom.