Rank of a record

[nikos_1283]

Hi everyone,

First, I apologize for my english level... I'm french and, whereas I read english very well, I'm very bad when I have to write something in. So, sorry, but I hope that you could help me here

So, I've made a database with 7 tables. This is an estimate system with a customer and a product database. What i want to do is to create a field in my Customers table that displays me the rank of the record in the table. I have a Total invoices field, and I want this field be the "ranker" (If customer A has 2 000€ of total, customer B has 3 500€ and customer C has 500€, I would like that Customer B rank field shows the number 1, the A shows 2 and then the C rank field shows 3.).

Merci beaucoup de votre aide ! and sorry for this "arranged" english :crazy2:

[Ano Nimus]

I don't know the answer to your question, but if it's easier for you to communicate in French, this is a good place:

(Je ne sais pas la réponse sur votre question, mais si c'est plus comfortable pour vous de discuter en Français, vous pouvez essayer ce lien: )

http://www.fmsource.com/forum/

[nikos_1283]

Thanks, I'll give it a try

Merci !