Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Adelaide,SA, Australia
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Record Selection (97)

    I want to select from a list of date contacted just the last three records to show on a customer report. The table needs to contain all the dates but only the last three are relevant for the sales person's information sheet. Ant help would be much appreciated
    Allan

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record Selection (97)

    I'm sure there are other ways to do this, but I would suggest using a query. Sort the data descending and use the TOP 3. The SQL should read something like: SELECT TOP 3 ContactDate FROM <YourTable> ORDER BY ContactDate DESC;

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Adelaide,SA, Australia
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record Selection (97)

    Thank you .. I must be brain dead today.. often use top three or more but didnt think of changing the sorting to descending order!!!... thanks for your help

Posting Permissions

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