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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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