I have one table that has 10k order detailed records with every order a vendor recieved for the month. I then created a query strickly for the purpose of creating a report. Currently the report shows all of the records on the table.
What I would like do is have what I guess would be a module pull a report by each vendor's name (One of the fields in the table) populate the report that is already created for just that vendor. Then email the vendor specific report to the vendor (The vendors email address is also one of the fields in the table)
I am thinking that it would be some type of For...Next logic but I am not very familiar with it or where to put the logic. Is it in the report, the qry that supplies the data to the report or in a seperate module that manipulates both.


Thank you for any help