| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return only 1 record w/ multiple records?
Hello,
Here is what I am trying to achieve. For order with multiple oper, it only returns one order with the lowest oper number. What can I do to achieve this. Thanks Table with the following data: Part Order Oper WC Date AAA 123 1000 8951 1/2/08 AAA 123 2000 8951 1/3/08 AAA 123 3000 8951 1/7/08 AAA 123 4000 8951 1/3/08 ABC 205 5000 8951 1/4/08 ABC 205 6000 8951 1/8/08 ABZ 314 1000 8951 1/3/08 AAH 380 2000 8951 1/3/08 result of query data I like to achieve: Part Order Oper WC Date AAA 123 1000 8951 1/2/08 ABC 205 5000 8951 1/4/08 ABZ 314 1000 8951 1/3/08 AAH 380 2000 8951 1/3/08 Records that are excluded: AAA 123 2000 8951 1/3/08 AAA 123 3000 8951 1/7/08 AAA 123 4000 8951 1/3/08 ABC 205 6000 8951 1/8/08 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to color 1 record of each set of Duplicate Records | Excel Worksheet Functions | |||
| return multiple records matching multiple criteria | Excel Worksheet Functions | |||
| to make a single row record become multiple row records | Excel Worksheet Functions | |||
| how do I set a record keeping template for church records? | Excel Discussion (Misc queries) | |||
| How to merge records into one record by customer's name? | New Users to Excel | |||
Threaded Mode
