Setting An ascending order 1

[crzycrystlgrl]

OK, CR9 + foxpro....
am trying to come up with a formula which will set an order to the number of exams a patient had been charged for.
So if I had a patient who had three exams (of which all have unique transaction ids) I need to find a way to label the first exam "1" the second one "2"...etc.
The only thought I have seems far too complicated and there has to be an easier answer...
Any ideas?
-Cynthia

 

[lbass]

Group by patient and then sort ascending by the date field. You can then insert a running total using the expert where you count {table.patientID}, evaluate for each record, reset on change of group (Patient). If there is more than one record per test, then in the evaluation section, have it evaluate on change of {table.testID}. Put the running total in the detail section to show a running count of test per patient.

-LB

 

[crzycrystlgrl]

thank you.