Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Sonrie
  • Content: Threads
  • Order by date
  1. Sonrie

    Numbering with a do-loop within a while-wend

    Hello, I have made a table where I print out data from a database. I would like to number all of the rows using this code: <% Do While Not rs.EOF i = 0 Response.Write(i) i = i + 1 Loop %> This should appear within this code: <% While ((Repeat1__numRows <> 0) AND (NOT rs.EOF)) %> ... <%...
  2. Sonrie

    Ranking positions

    Hello, I have made a query where I select data about a contestant and his total points and results in a competition. I have ordered these on total score. I want to rank each contestant in a competition on who has the best results. Best contestant – position 1, 2nd best contestant – position 2...
  3. Sonrie

    Order by an alias

    Hello, I would like to set an alias to this Select-line, but it won’t work: (SELECT SUM((rr.points) + (rr.result)) FROM roundresult rr WHERE rr.contid = contestants.contid) I have tried with and without AS and also with and without ‘ and “. Nothing seems to work. I would like to order the...
  4. Sonrie

    Select posts and totals of posts

    Hello, I am working on a query for an Access Database. It’s a database about a competition where the results for the round are registered at the end of each round. I want to make a list of results where I select the data about the contestants and their results for each round. The tables are...
  5. Sonrie

    Select posts where the ID is not within all of the posts

    Hello, I am working on a query for an Access Database. It’s a database about a competition where the results for the round are registered at the end of each round. I want to select data about the persons in the register who have never competed or not competed in one or more of the rounds. The...

Part and Inventory Search

Back
Top