Hi
Firstly I'm using Access 2003 for my little project.
I've got a bit of a problem. Basically I've been designing a database which has a table for supplier contact details,another containing a list of all the queries we have with each supplier and a query to filter for anything that hasn't been resolved. I have worked out how to send each individual query to the assigned supplier but I now want to create a means of sending each supplier their outstanding list of queries as a report but being new to this I'm getting confused on how to get Access to filter for the first account output it as a report and send it to the supplier then move on to the next suppler send that and so forth till their is none to send. If anyone can produce this in a lame mans terms that would be fantastic.
Regards
Gary
Firstly I'm using Access 2003 for my little project.
I've got a bit of a problem. Basically I've been designing a database which has a table for supplier contact details,another containing a list of all the queries we have with each supplier and a query to filter for anything that hasn't been resolved. I have worked out how to send each individual query to the assigned supplier but I now want to create a means of sending each supplier their outstanding list of queries as a report but being new to this I'm getting confused on how to get Access to filter for the first account output it as a report and send it to the supplier then move on to the next suppler send that and so forth till their is none to send. If anyone can produce this in a lame mans terms that would be fantastic.
Regards
Gary
Comment