Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    3

    Unanswered: Automaticly removes lower number lines

    I have a database with two major tables.
    Each time some does something with an item there comes a new line in an particular table. I want a query who makes a table witch only teh last lines ( lines with the highest number).
    Do you have a solution ????

    Thanks for trying.

    I enclosed an example !

    Wim
    Attached Files Attached Files
    Last edited by Accesswim; 02-17-05 at 16:47.

  2. #2
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    Look at the Top or Max functions.
    Darasen

  3. #3
    Join Date
    Feb 2005
    Posts
    3
    Thank you for your answer, would you please be so kind to programm your solution in my example. I think you did not understand my question, or I was not exactly in my question, so I can check if this was where I was looking for.

    greetings

    Wim
    Last edited by Accesswim; 02-17-05 at 16:52.

  4. #4
    Join Date
    Feb 2005
    Posts
    3
    Problem solved

    Thanks for helping

    Wim

Posting Permissions

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