Hi,
you need to use the VBA along with a parameter query.
Move through your division name table, at each record storing the
uniqueID / division name to a variable, and then open/print a query
based report where the query parameter refers to your stored variable.
hth,
Owen
--- In [EMAIL PROTECTED], redpatski <[EMAIL PROTECTED]> wrote:
> Hello, I have a challenge I'm hoping someone can help me with. I have
> one table which has a list of our divisions. Then I have some code that
> runs a series of data manipulation queries for a division, resulting in
> a report at the end. I want the code to do the same procedures for each
> division, processing each of them separately.
>
> What is the best way to do this? In other words, I'm passing the
> division number as criteria for the query, one division at a time.
>
> I've tried a number of options but I'm only confusing myself more.
> Might say I'm getting "loopy".
>
> Thanks for the help. Much appreciated,
>
> Pat
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
