Search results

Hello, i have number fields in a table (1-6), 1. HeelonLeashandFig_8 40 points 2. StandforExamination 30 points 3. HeelFree 40 points 4. Recall 30 points 5. LongSit 30 points 6. LongDown 30 points 7. Total score (1+2+3+4+5+6=) 8. qualifying now i want that field [qualifying] will be...

Hello, with my SQL code i can make a ranking. But if there are two or more with the same time and score the ranking is wrong. lets say if there are two with the same score and time the code gives them 4 place instead of place 3. SELECT a.RallyKlasnaam, a.naamhond, a.Exhibitor, a.Rallydognr...

Hello, i have a database for dog competion. they are getting a sore and time. the highest sore wins but if there is a equal sore the fastes wins. I had already somting but is get a error invalid use of null. SELECT a.RallyKlasnaam, a.Exhibitor, a.Rallydognr, a.Score, a.Time...

Hello, i have a competition DB. But i want to calculate the winner of the game. you get points the highest one wins but if there is a draw then the time has to be checked as well. how can I do that. thanks

Hello, i'm working whit access for my work. i do it already 8 years. And I hope that I can get some answers and maybe I can help some people. greetings Allard