Property #/Unit#/ Unit Sq Footage / AS of Date

 

I am trying to write a Crystal Report that would show the last unit sq footage in the database but am having trouble. I am able to do this in Access by grouping the data and using the "Last" criteria but can't find the right function in Crystal.

 

Here's a sample of the data: Table Name is Property_Unit_Sqft

 

1109-4224-2000-6/9/2009

1109-4224-2250-7/1/2009

1109-4224-2200-12/31/2009

1110-0110-1500-1/1/2009

1112-0220-1000-1/31/2009

 

I would like the report to show the lastest square footage for Unit 4224 of 2200 but I'm getting all 3.

 

Hope some one can help me.

 

Thanks