Ranking on a form

[ericthered2650]

i know there are plenty of people who ask about ranking on a query but what i
need is a way of performing a rank on the results on a form.

I have a form that adds the calculation from other fields. I then want to
produce a numerical rank in another text box.

Eg
T1 T2 Total Rank
13 14 27
12 18 30
18 9 27

I have only a basic understanding of vbasic and sql so i need very easy to
follow instructions

Thanks