I'm trying to find and use information from records as follows:
1) I have a field called Sounding_LT on all records. Such field could be empty or have a value (number);
2) I have to get from the records, the first one that has a value and the 4th one that also has a value, so I can manage to do calculation using those two numbers;
3) As I could not make it work as described above, I tried to get the values from a search, linking two new fields (Sounding1 and Sounding2, numbers, global) to the dates range, where I would have the information pulled from the record where start date matches date of the first sounding and the end date matches the date for the second sounding;
- It works for the Sounding1, but not for Sounding2...
Please let me know if more clarification is needed.