Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Specifying filtering criteria for ms query in excel
Hi all
I have an excel database with laboratory results stored in it. The results does not have fixed sequence (i.e. is not logged dayly, weekly, monthly, etc). However, I need to draw a monthly report on the results that have been logged for the period. Using a vlookup function dont work for me, as I cannot specify the actual dates for logging (because I dont always know), and draw the results from that. I was playing around with storing the excel spreadsheet as a DB, and creating a separate reporting spreadsheet. I then use MS Query to draw the specific results for the perion, using a filter on the date, to return only the data bor that period. However, if i want to change the reporting period, I have to go back to the query everytime, and go change the filtering criteria. Is there is way that I could specify the filtering criteria within the reporting spreadsheet? Regards Lasca |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Specifying filtering criteria for ms query in excel
Lasca wrote:
Hi all I have an excel database with laboratory results stored in it. The results does not have fixed sequence (i.e. is not logged dayly, weekly, monthly, etc). However, I need to draw a monthly report on the results that have been logged for the period. Using a vlookup function dont work for me, as I cannot specify the actual dates for logging (because I dont always know), and draw the results from that. I was playing around with storing the excel spreadsheet as a DB, and creating a separate reporting spreadsheet. I then use MS Query to draw the specific results for the perion, using a filter on the date, to return only the data bor that period. However, if i want to change the reporting period, I have to go back to the query everytime, and go change the filtering criteria. Is there is way that I could specify the filtering criteria within the reporting spreadsheet? Regards Hi Lasca, Funny you should ask as today I worked through the exact same question about MS Query. This site told me everything I needed to know: http://www.dailydoseofexcel.com/arch...-data-queries/ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Specifying filtering criteria for ms query in excel
smartin
Thank you very much for the assistance. Really saved me a lot of time that I would have been struggling with this issue. Regards Lasca "smartin" wrote: Lasca wrote: Hi all I have an excel database with laboratory results stored in it. The results does not have fixed sequence (i.e. is not logged dayly, weekly, monthly, etc). However, I need to draw a monthly report on the results that have been logged for the period. Using a vlookup function dont work for me, as I cannot specify the actual dates for logging (because I dont always know), and draw the results from that. I was playing around with storing the excel spreadsheet as a DB, and creating a separate reporting spreadsheet. I then use MS Query to draw the specific results for the perion, using a filter on the date, to return only the data bor that period. However, if i want to change the reporting period, I have to go back to the query everytime, and go change the filtering criteria. Is there is way that I could specify the filtering criteria within the reporting spreadsheet? Regards Hi Lasca, Funny you should ask as today I worked through the exact same question about MS Query. This site told me everything I needed to know: http://www.dailydoseofexcel.com/arch...-data-queries/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Applying Criteria in Excel Cell to MS Query Pull from Access | Excel Discussion (Misc queries) | |||
Filtering by criteria within PV in Excel. | Excel Discussion (Misc queries) | |||
Filtering by criteria within Pivot Tables in Excel 2000 | Excel Discussion (Misc queries) | |||
Using A Cell In Excel as Criteria for a Query | Excel Discussion (Misc queries) |