Recent content by Sonrie

Hehe, yes, I do! ;O) Thanks for the tip. -Sonrie

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)) %> ... <%...

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...

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...

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

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

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”...

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...

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...

Thank you! It worked! Sincerely, Sonrie

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

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...

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...

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...