Results 1 to 4 of 4

Thread: Qwery?!

  1. #1
    Join Date
    Jul 2004
    Location
    Latvia
    Posts
    13

    Unanswered: Qwery?!

    When i print REPORT, how i can make that it print only first 15 records?!

    tnx

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select top 15 * from tableA

    Alternatively, if you wish to return records 11-20 then,

    Select top 20 *
    from tableA
    where key NOT IN
    (select top 10 key
    from tableA)
    Last edited by r123456; 07-14-04 at 10:01.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Change the RecordSource of your report and say SELECT Top 15 From your Table .....

    Do that in the Properties Window under DATA Tab, then the thired Itme which is RecordSource click the three points on the right hand side choose your query or write your own SQL ..
    Last edited by hammbakka; 07-15-04 at 02:56.

  4. #4
    Join Date
    Jul 2004
    Location
    Latvia
    Posts
    13
    tnx it`s helps

Posting Permissions

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