Question group table to the query

[iraidotel@yahoo.com]

Dear Experts, elders Access

Dh,
Please enlighten her, I want the group table to the query, the same data will be in the group and at the beginning and depth_to grab his Depth_from taken last.
until now I have not succeeded, I try to use MIN, MAX can not, Wear FIRST and LAST also unsuccessful
may co-exist together experts who can provide a way of solving it,
I attached excel file to its table

hopefully help anyone help me

Thank hopefully healthy kalain always

greetings, Ira Borneo

 

[CJ_London]

you need another column to indicate layer/level

this query

 SELECT Table3.Hole_ID, Min(Table3.depth_from) AS MinOfdepth_from, Max(Table3.depth_to) AS MaxOfdepth_to, Table3.maj_rock, Table3.desc
FROM Table3
GROUP BY Table3.Hole_ID, Table3.maj_rock, Table3.desc;

produces this result

The row highlighted in yellow is not producing the correct min depth because of the records highlighted here