Search results

i don't understand that.

oke, the switch statement. My question is a little bit different. All of the fields have to be above 50% and a total of 170 >. And then you get a Q. if one of the scores is less than 50% there is no Q

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

Thanks it works.

RallyKlasnaam- text naamhond-text Exhibitor-text Rallydogn- number

undedined Function 'fnRanking' in expression this is gone now. My stipid misstake i had call de module the same as the fuction. But now is there a Ranking #Error !!!!!

oke sorry i thought i had to fit it to my DB. i have put every ting back and now i get; undedined Function 'fnRanking' in expression !!! [Time] and [Score] "Tbl_ResultsRally" is are numbers

Now i get a error in [Ranking].test So this is my code in "qryForRanking" SELECT Tbl_ResultsRally.RallyKlasnaam, Tbl_ResultsRally.naamhond, Tbl_ResultsRally.Exhibitor, Tbl_ResultsRally.Rallydognr, Tbl_ResultsRally.Score, Tbl_ResultsRally.Time FROM Tbl_ResultsRally; this is the public...

Hello, thanks alot,but i get a fault, The expression contains an undefined function fnRanking. what am I doing wrong. i have made de first query, the code i put it a module, And make the second code called test for now.

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

Sorry for the late response. 1. With the SQL code i have my results there is not the problem 2. the null error, it's because TBL has a lot of empty cells that why i get the null error. 3. I made a make TBL query with only a speciafik RallyKlasnaam and date. so i resolve 2 and 3. My main...

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

i get attachment.php

@Plog, Based on the score i want a raking and if there is a tie the fastes time wins. @arnelgp, the attached file i can not open it.

this is a sample database. i want in my report for each level placed from 1st to the last based on the score. but if there is a tie there has to be looked to the time and fastes time wins. thanks

Yes there is a Date/time Field. but how can a compare between the two records.

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