Thank you sir for your time. please sir  give me with an example how to use the ORDER BY to rank students scores in a particular subject and to create a different column for the result, you can include the DLOOKUP function, I need it with example sir. Thanks once more in anticipation.

---

Reply from Alex Hedley:

The DLOOKUP function is shown in Expert 10.
Sorting is shown in Beginner 1. I'd advise going through 1 fully to learn how to create a simple Db, add Tables, Fields and work with that data. You'll need a good grounding before moving onto the Expert series.