how do you select the last entry from a field

[jp246]

I am wanting to know hawo to ask crystal to select the last entry made in a table: example

Assessment_Date Care_type

Oct 19, 2006 long term
April 21, 2003 short term

I need to pull the last data entry made by the nurse into my report - the last assessment_date of Oct 19, 2006 and then the last care_type of longterm.

I am running this report by the service_ deliverydate of Dec 1 -31, 2006, but only need to display the last assessment date and the care type.

thanks

 

[lbass]

I'm guessing you are trying to get the most recent date per some group, maybe on nurse? If so, then go to report->selection formula->GROUP and enter:

{table.assessmentdate} = maximum({table.assessmentdate},{table.nurse})

Or substitute your actual group field for {table.nurse}.

-LB