PDA

View Full Version : Get series first line



Magnus1982
04-17-2019, 01:10 PM
Hello everyone,

Let my introduce my problem .Imagine I have query with date

PL:1234AA:DF1324BD0001
PL:1234AA:DF1324BD0002
PL:1234AA:DF1324BD0003
PL:1234AA:DF1324BD0008
PL:1234AA:DF1324BD0009
PL:1234AA:DF1324BD0010
PL:1234AA:DF1324BD0011

I need trasnfer to another query or to the some text field first line of series. In this sample in next query or text field in the report i shoud have only lines with red font. Basiclly I am looking way to cach first line in data series.

Any sugestion , codes, solution

Thank you for help

OBP
04-17-2019, 02:05 PM
2 ways in a query
1 use Max or Min function, depending on whether it is the first or last date
2. Use the nth number of records set to a value of 1.