Jump to content
Sign in to follow this  
nikos_1283

Rank of a record

Recommended Posts

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 :smile2:

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:

Share this post


Link to post
Share on other sites

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/

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.