query group by

[fanfan2]

I have the attached table, I would like to group by ID and if there are consecutively same codes, group by codes, then pick the minimum valueA and maximun valueB within the group. I couldn't make it work, because if I group by ID and then group by code, then it picks all the same codes within the ID (not just the consecutive ones). Any help would be appreciated.

[ajetrumpet]

i tell you what would be of tremendous help to me in order to help you would be if you provided a result table of what exactly you want the outcome to look like, if the query was run on the table you've already uploaded here. if you do that, it would easier to tell you if it is possible in 1 qry, or if you would need 2. most likely you will need 2 anyway

[fanfan2]

The tables are attached. one is the original table, the other is the result table I would like to have. Thanks very much.

[ajetrumpet]

The tables are attached. one is the original table, the other is the result table I would like to have. Thanks very much.

this will take a bit of thinking, and you will need a module to do it. if you're willing to pay for the time to figure it out, I'd do it for you. if not, you will need to research vba recordsets...