manix
Registered User.
- Local time
- Today, 16:23
- Joined
- Nov 29, 2006
- Messages
- 100
Hi All,
I currently have a complex array of tables and queries that create a report - A supplier performance scorecard. This score card is a report of a supplier performance over a given space of time.
Currently, the query used to create the report looks at x3 combo boxes that the user fills in and runs the query to produce the report. These combo boxes are:
Start Date
End Date
Supplier Name
Now this allows the user to create a report for each supplier one at a time. My issue is that although this works, it's time consuming, especailly if you have to report many suppliers for a given period.
Now the database knows whether a supplier has delivered in a given period, so what I would like to do, is enter Start Date and End Date and click a buttone to produce all the reports at once, based on all those suppliers who have delivered in the period defined by the Start and End Dates.
This is a bit beyond my knowledge, but can anyone provide a possible solution? Basically I would like to have it create PDFs for each supplier and plonk them somewhere on a newtworked drive so we can then mail them out.
The database was built in Access 2003 but I now run Access 2010. This operation runs purely off a series of queries and does not currently make use of any macros or advanced VBA.
Any help would be most appreciated.
I currently have a complex array of tables and queries that create a report - A supplier performance scorecard. This score card is a report of a supplier performance over a given space of time.
Currently, the query used to create the report looks at x3 combo boxes that the user fills in and runs the query to produce the report. These combo boxes are:
Start Date
End Date
Supplier Name
Now this allows the user to create a report for each supplier one at a time. My issue is that although this works, it's time consuming, especailly if you have to report many suppliers for a given period.
Now the database knows whether a supplier has delivered in a given period, so what I would like to do, is enter Start Date and End Date and click a buttone to produce all the reports at once, based on all those suppliers who have delivered in the period defined by the Start and End Dates.
This is a bit beyond my knowledge, but can anyone provide a possible solution? Basically I would like to have it create PDFs for each supplier and plonk them somewhere on a newtworked drive so we can then mail them out.
The database was built in Access 2003 but I now run Access 2010. This operation runs purely off a series of queries and does not currently make use of any macros or advanced VBA.
Any help would be most appreciated.