find latest record

Results 1 to 2 of 2

Thread: find latest record

  1. #1
    Join Date
    Dec 1969

    Default find latest record

    Hi, I've been working on a web database thats almost complete. I need to be able to find the latest record in one table using a date field, based on the value of a field in another table. I'm using Access 97 with ASP(vbscript and javascript)any ideas?

  2. #2
    Join Date
    Dec 1969

    Default Yes...

    select top mydatecolumn from mytable<BR> order by mydatecolumn 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