Thank you. Do you know of any code samples that do this...either
here, in a book or on the Internet? It would help if I could dissect
some similar code. I can't find any examples that match these
requirements.
--- In [EMAIL PROTECTED], "owen_group_profile"
<[EMAIL PROTECTED]> wrote:
> 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/
