Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    36

    Unanswered: TopRowVisable of continuous forms

    ok - what i want to do is work out what record is topmost displayed on a continuous form

    for example 100 records may be on a continuous form - i can see records 10 to 20 on the screen - in this case i want to return 10.

    thanks in advance
    kris bennett

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the select top n may be appropriate for you

    eg select top 10 <mycolumnlist> from <mytable> order by <mysortorder>

Posting Permissions

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