Thank you for your post.
If you have the amounts in a related table, you can use the Sum() function to total those amounts.
Create a calculation field, and for the formula, enter:
Sum (<related table name > :: <related field name> )
For example, if you are in a CUSTOMERS file, and you are trying to total the "Amount" field in the ORDERS table, the formula would be:
Thank you for the idea...
But in fact, I'm trying to keep it in the same table ORDER (because the orders are just examples, in fact this is a fidelity program with points...)
An idea ?
A Summary field allows you to total, average, count, etc.
When you define a field, select the field type as "Summary". Since you want to total an "Amount" field, set the field to Total the Amount field.
If you have this field on the layout, you can display a total for all records, or you can find a subset of records and display that total.
STOP ! You gave me the solution...
I've just made a relation on itself...
ClientID is related to ClientID in the same table, with the name AUTO ; than, a new field SUM (AUTO::ClientID) !
And it's ok !
Thank you !!
Good night ! (11:27 PM !)