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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Sonrie

  1. Sonrie

    Numbering with a do-loop within a while-wend

    Hehe, yes, I do! ;O) Thanks for the tip. -Sonrie
  2. 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)) %> ... <%...
  3. Sonrie

    Ranking positions

    Hello, Yes, the position is derived from the score achieved in the competition. I tried that, but I want to have the number 1, 2, 3, and so on in the Ranking-field. Now I only get the same scores as in the CompetitionScore-field. How is it possible to show the contestants position number in...
  4. 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...
  5. Sonrie

    Order by an alias

    It worked now - after I put in a join-line. Thank you! Sincerely, Sonrie
  6. Sonrie

    Order by an alias

    I am not sure how to use a join here. How do I include all of the subselects? Sincerely, Sonrie
  7. Sonrie

    Order by an alias

    Hello again, I tried this, but it won't work. I have about 12 Select-lines within parenthesis in the Select-line, like this: select a, b, (select c from x where ...), (select d from x where ...), (select e from x where ...), (select f from x where ...) from y order by 3 desc; The “order by”...
  8. 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...
  9. 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...
  10. Sonrie

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

    Thank you! It worked! Sincerely, Sonrie
  11. Sonrie

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

    Sorry, wrong query: SELECT COUNT(Round) FROM (SELECT DISTINCT Round FROM Roundresults);
  12. Sonrie

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

    In the table Round there are registered 5 rounds (total rounds for the competition). But in Roundresults there are only registered the results for the 3 first rounds (the rest will come later…). I want to select the contestants that are: 1) not registered in any of these rounds 2) and, is...
  13. Sonrie

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

    I tried that, but it retuned all of the names X times. When I put DISCINCT after SELECT it returned all the names of the contestants - but only once. Why doesn't your tip work? I want to list out the data about the contestants that have never competed, or not competed in one or more of the...
  14. 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...
See more

Part and Inventory Search

Back
Top