G
Guest
A beginner got stuck...
I have a set of marine measurements at various stations and dates, taken at
several depths (horizons). I want to use a query, to find the measurement for
each station and date that is taken closest to a fixed depth, let's say 25 m.
I can use the query grid to create a query that lists each sampling occasion
(using group by on station and date) and I can also find the mimumum distance
to my 25 m, using min on a field that contains the absolute value of the
difference between sampling depth and 25 m. But how do I add a field, that
would contain the depth at which this sample is actually taken?
It would be nice if someone could help.
- Baerbel
I have a set of marine measurements at various stations and dates, taken at
several depths (horizons). I want to use a query, to find the measurement for
each station and date that is taken closest to a fixed depth, let's say 25 m.
I can use the query grid to create a query that lists each sampling occasion
(using group by on station and date) and I can also find the mimumum distance
to my 25 m, using min on a field that contains the absolute value of the
difference between sampling depth and 25 m. But how do I add a field, that
would contain the depth at which this sample is actually taken?
It would be nice if someone could help.
- Baerbel
