Select Query

Results 1 to 3 of 3

Thread: Select Query

  1. #1
    Join Date
    Dec 1969

    Default Select Query

    I have question regarding select maximum number or ID from my database. I use Microsoft Access. Does anyone know how to write the query

  2. #2
    Join Date
    Dec 1969

    Default ummmm.

    SQL = "select max(fieldname) from tablename"<BR><BR>or SQL = "Select fieldname from tablename"<BR><BR>-- Whol

  3. #3
    Medieval Dude Guest

    Default RE: Select Query

    You mean something like this?<BR>SELECT TOP 1 ID FROM mytable ORDER BY ID 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