Search results

I will! :) Thank you! Maby I can send the bill to you? hehehe :)

After a lot of testing....it is PERFECT!! Thank you both!

Now I have copyed the Module into my database, and it seems to work!! I will test it little bit more, and I will give you a reply! Thank you both!

Thank you! I have now put it into my database, but I get this message: "Undefined function getRanking in the expression"!! SELECT Kl1Lær1.Navn, Kl1Lær1.Speilnr, Kl1Lær1.Dommer1kl1, Kl1Lær1.Dommer2kl1, Kl1Lær1.Dommer3kl1, Kl1Lær1.Sum, getRanking([Sum],"Descending") AS Ranking FROM Kl1Lær1 ORDER...

You do not have to Apologie. I appreciate very much that you are trying to help me. And I know that my English is not so good ...... I would appreciate it if you try again! THANK YOU AGAIN!!

I try again. I want it to be ranked as Excel do it. :rolleyes:

This is what I wrote in my Original Post: I want to create a new column that is ranked by column POINTS. And it should work like this: 1 2 3 3 5 So is the score on the third place in the POINTS equal, then the next will be 5. I`m sorry if you feel that I waste your time!!!

And I`m afraid that is the correct way to do it! :) Here is an example from the PGA tour in golf: RANK PLAYER ROUND THRU TOTAL T1 Ben Crane -9 F -16 T1 David Toms -7 F -16 T1 Mark Wilson -10 F -16 T4 Camilo Villegas -4 F -13 T4 Harris English -10 F -13 As you see the three first has the same...

Hello again! Now I saw something that is not correct. As you can see from the attachment PNG, the number one and two has the same points, and will then get place 1, and that is correct. But the next person should have place 3 - NOT place 2! Is it possible to fix it?

You was right!! :) I didn't put txtGrpCount textbox in the group's header.... Now it is PERFECT! Thank You very much!!

Thank you, but this did not work... Now, everyone is number 1 in the report.(See the attached PNG file). But if I Export the report to Excel, it is correct!(See the attached Excel file) Have I done something wrong?

Did you see the attached file now? (Klipp1Lærling.xls) I have 3 Dommere. Sum: [Tabell1]![Dommer1]+[Tabell1]![Dommer2]+[Tabell1]![Dommer3] This works! :) But I don`t know how to get the right Rank.

Here is the Excel file!!

Lokks like the attachment file is missing! But i should look like this: Nr. Navn Dommer 1 Dommer 2 Dommer 3 Poeng 1 Sigrun 10 12 12 34 2 Kari 12 10 9 31 2 Britt 9 13 9 31 4 Jorunn 8 9 12 29 5 Geir 7 8 7 22

Nr. Navn Dommer 1 Dommer 2 Dommer 3 Poeng 1 Sigrun 10 12 12 34 2 Kari 12 10 9 31 2 Britt 9 13 9 31 4 Jorunn 8 9 12 29 5 Geir 7 8 7 22

Sorry, there was a little off because I have translated from Norwegian into English. I have six columns, and it looks like this: Nr. Navn Dommer1 Dommer2 Dommer3 Poeng 1 Sigrun 10 12 12 34 2...

Hi Sorry my bad English! I hope however that someone understands my question and can give me an answer! I am trying to create a program in Microsoft Office Access 2007. I have 7 columns in my report: Name, No Mirrors, Judge 1, Judge 2, Judge 3, Klipp1 and POINTS. I want to create a new column...