-
Get series first line
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
-
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.