Do while loop

  • Thread starter Thread starter vavs
  • Start date Start date
V

vavs

I have a database of "Approvers" who need to have a report sent to them next
month. There are 70 approvers. I have an access report based on a query
with the first sort field being Approver. I have a table called
DistinctApprover which has each distinct approver name. I need to create a
loop to select the first name in the list, put that value in a variable
AppName and then I will walk through the code to create the report, save it,
close it and then go and get the next name. I have done this in excel but I
am new to access and need to find a little help to make sure I do this
correctly. I have seen where the distinct function can be done in the code
where I do not need another table to be created. Also, this entire function
is triggered from a button on a form.

I know enough to know I am definitely up to my chin, can anyone help?
 
Iterating through a table is not a very "Access" way of doing things, such
an approach would normally be a last resort.

The most obvious approach is to create a single report for all of the
approvers, with a separate page (or pages) for each one.
 
Back
Top