I'd be willing to give it a shot....at this point nothing's working yet. Thanks.
--- In [email protected], "owen_group_profile" <[EMAIL PROTECTED]> wrote: > Hi Pat, > > I've got some sample code for building the parameter query into the > VBA, will that be ok on it's own? (are you comfortable with building > the recordsets etc if I give a brief description of what's needed?) > > Owen > > > > --- In [email protected], redpatski <[EMAIL PROTECTED]> wrote: > > 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/
