Looping through Parameter Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CCross - 25 Jan 2006 20:11 GMT

I currently have a parameter query that runs from an unbound form where I can
select from 95 different criteria and then run the query. This is great, but
I would really like to be able to loop through the 95 criteria without having
to select each one individually. Is this possible?

Reply to this Message

Jeff Boyce - 26 Jan 2006 00:06 GMT

If you are saying you want a query to run 95 times, each time with a
different criterion, consider doing this in a procedure, using the query's
SQL statement, and dynamically altering the SQL statement each time before
it executes.

Regards

Jeff Boyce
<Office/Access MVP>

>I currently have a parameter query that runs from an unbound form where I
>can
[quoted text clipped - 3 lines]
> having
> to select each one individually. Is this possible?

Reply to this Message

CCross - 26 Jan 2006 19:50 GMT

Could you give me a sample sql statement?

> If you are saying you want a query to run 95 times, each time with a
> different criterion, consider doing this in a procedure, using the query's
[quoted text clipped - 13 lines]
> > having
> > to select each one individually. Is this possible?

Reply to this Message

Jeff Boyce - 26 Jan 2006 22:07 GMT

Take one of your existing queries. Open it in design mode. Change the view
to the SQL view. That's the SQL statement that the query uses.

Regards

Jeff Boyce
<Office/Access MVP>

> Could you give me a sample sql statement?
>
[quoted text clipped - 19 lines]
>> > having
>> > to select each one individually. Is this possible?

Reply to this Message