i am new in this forum and on crystal reports. I am currently using crystal reports 8.5 (old version already).

  I have already linked the tables ill be using on my report query. However I am having a hard time figuring out how to get the maximum value of a certain field in my report.

  My problem is that i need to know the updated address of a certain customer for my report. If theres a new address for said customer, the address table will increment its address_id field value just like the figure shown below which shows houston texas as john doe's current address.

 

address_id	cust_code	cust_name	address
1	1001	John Doe	san diego, california
2	1001	John Doe	houston, texas

 

I already figured out this problem in sql by the following codes:

 

select *  from address where cust_code = 1001 and address_id in  (select max(address_id) from address where cust_code = 1001)

 

but cannot figure out how to do the same thing using crystal report's EDIT SELECTION FORMULA window. Any help will be very much appreciated.

 

thanks....