Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
nested query
I have a table that contains Emplid, date, action data as below
Emplid, date, action 2000, 01/01/2007, PAY 2000, 02/02/2007, LEAVE 2001, 03/01/2006, HIRE I am trying to write MS query in Excel that would fetch me for any emplid given at runtime and with maximum date. when I run the query it should ask me to input emplid (e.g 2000) and expected result should return as below 2000, 02/02/2007, LEAVE when I rerun the query with different emplid it should give me highest date row. your help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
nested conditional query | Excel Discussion (Misc queries) | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
A query in continuation to the nested bordering - To TOM, JIM and others.... | Excel Programming | |||
What is quicker? Nested or non nested ifs | Excel Programming |