I am using access to export a parameter query into excel.
Upon the arrival of the data on the first workbook, I was wondering if it were possible to have the data duplicated onto other worksheets based on some criteria (location).
example...all of the entries on the DB have a location.
In access if I ran the query to see all the work from a certain week and clikc export, each entry would have 1-5 for a location. on the following work pages I want to find all of the 1's, all of the 2's and so on.
Does that make sence?
Is that possible?
thanks for your time
SL
Upon the arrival of the data on the first workbook, I was wondering if it were possible to have the data duplicated onto other worksheets based on some criteria (location).
example...all of the entries on the DB have a location.
In access if I ran the query to see all the work from a certain week and clikc export, each entry would have 1-5 for a location. on the following work pages I want to find all of the 1's, all of the 2's and so on.
Does that make sence?
Is that possible?
thanks for your time
SL