title: How to use a list of records as filter to run a macro in Access 2007
body: <p>I am kind of a newbie to programming in Access and there might be an alternative way to do what I intend, but I hope someone can help me.</p>
  
  <ol>
  <li>I have a query with 5 fields: Date, Salesperson, Item, Quantity and Value.</li>
  <li>In my database I have around 600 differente Salesperson</li>
  <li>I have a report that is linked to the query mentioned on 1. and basically puts the information in a table format, in order to print it.</li>
  </ol>
  
  <p>What I am trying to do is to build a macro that gets Salesperson 1, filters the report with that record on the corresponding field, prints the report to pdf file with the Salesperson name and Date and then goes for the next Salesperson, and so on until it reaches the last Salesperson.</p>
  
  <p>In short, I need to end up with a pdf file for each Salesperson that shows up in the query.</p>
  
  <p>I have searched for a solution, but nothing got close to what I need.</p>
  
  <p>Hope someone can help or at least guide me in a possible way to accomplish this.</p>
  
  <p>Best</p>
  
  <p>Jorge Santos</p>