using next and previous and SECOND

[GaryWilsonCPA]

I am using next and previous to look up first and last records in a file by patient id.

ClientID = Next (clientid) "gets me the last record in file"

ClientID = Previous (clientid) "gets me the first record in file"

How can i get the second record in a file???

 

[Madawc]

In Crystal 8.5, you could group by patient id, and then do a running total for records within the group. Check when the count is two.

Madawc Williams
East Anglia, Great Britain

 

[IdoMillet]

Gary,

Please clarify. Next & Previous can only get the value in the next/previous record, not the first and last record.

If you explain the data structure with a bit more detail and the desired report output it would be easier to suggest a solution.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com