I recently download the lahman database and I had a very easy question i was hoping someone would help me with. Im pretty much new to access but I been playing around with the queries and im getting the hang of it slowly. I can seem to do queries involving single seasons but im having trouble with cumulative totals.

For instance.......say I wanted a list of the top ten all-time leaders in home runs.....how would I go about doing that. As you know the database is broken into years......so im unsure how i would do something cumulative. Thanks for your help