Consulting

Results 1 to 2 of 2

Thread: Get series first line

  1. #1

    Get series first line

    Hello everyone,

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

    PL:1234AAF1324BD0001
    PL:1234AAF1324BD0002
    PL:1234AAF1324BD0003
    PL:1234AAF1324BD0008
    PL:1234AAF1324BD0009
    PL:1234AAF1324BD0010
    PL:1234AAF1324BD0011

    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. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,086
    Location
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •