Record list

Results 1 to 4 of 4

Thread: Record list

  1. #1
    Big Al Guest

    Default Record list

    Is there any way to retive the last 4 records hich have been entered to a data base. I have been thinking of ways to do it but just come up blank....

  2. #2
    Join Date
    Dec 1969

    Default RE: Record list

    Do you have an IDENTITY or AUTONUMBER field in your record layout? If so, you can do a SELECT query using TOP 4. If not, do you have a date/timestamp? If so, you can still use the TOP 4. If not, you are pretty much out of luck.

  3. #3
    Big Al Guest

    Default but how

    I do have an autonumber field but how do I then get the top four records back?

  4. #4
    jharris Guest

    Default RE: but how

    SELECT TOP 4 * FROM mytable ORDER BY autonumberfield DESC.

Posting Permissions

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