Automatic Record Numbering

This is working only for Integer numbers (ID number). But when I use numbers with coma (the exam scores for  students) It's showing "#error". Please I'm still in need of help.

How did you define your score field? Use number format "Double".

The scores field is a calculated field in a query.

Calculated based on what fields?
Are those fields defined correctly?
What is your calculation?

DCount

Something like
DCOUNT("*","StudentT","Score<=" & Score)

Also that assumes it's a number field just with formatting to add the commas, if they are real commas and it's a text field you would have to convert it to a number first.

All the fields I used to calculate the "Score" field are formated "real Double". So the  "Score" field is real double too. The Dcount function consider the coma as a syntaxe error.
So I tried This in the query:
1. I created a field that convert the score field from "real double" to "Integer" using this sintaxe "S:Fix(Score*1000000)"
the "1 000 000" is just a factor that allows me to avoid similar numbers ( 9.45536 and 9.89992 are same for "Fix" function)
2. I used the DCOUNT function with the "S" field.
Now it's working!
Let me know if there is a better way.
You have just saved my life
THANK YOU