I've only been using Crystal reports for about 45 minutes and I'm  stuck already

 

Up until today I've been using MS Access for all my database connectivity reporting activities.

 

I have a report that selects the very last record based on a parameter, bringing up all companies were the very first transaction is greater than parameter, which in Access looks like :-

 

HAVING (((Last(transactions.transaction_date))>=[Date])

 

This brings up the all companies were the very 1st transaction was after the parameter date.

 

Is there an equivalant in Crytal Reports?

 

I've tried using the Minimum function and that brings up all records that have a Minimum value after the given parameter, not the first record.

 

Apologies if the answer to this is staring me in the face, I've had a google about to no success.

 

Thanks

 

Flea