I have a simple select query which compares if the product quantity is less than the minimum stock level if it is the query returns the records. These records then need to be reordered. However they need to be reported by supplier_ID (this is in my query). My question is how do i generate a report by supplier so that if i had lots of products from 3 different suppliers i would generate 3 seperate reports from my one template?
create a new query and put the address data form the Supplier table
create the report
them click the [(= sorting and Grouping and group them by the Supplier_ID
then read the other option on the screen some about Keep together
that will create a new head in the report put the supplier details in that part of the report and pruducts in the details
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.