I have a table in MS Access that has time related data and I need to select only the pressure at the minimum depth and maximum depth for each well in each time.
Please find the MS Access table attached and I am expecting to have the following results from the query.
Well Date Pressure_Min_depth Pressure_Max_depth
1 1/1/2013 2333 46784
1 3/22/2014 6768 54654
2 4/1/2014 2333 6768