Finding the most current date among many 1

[DonSaluga]

I have two tables, job and job_history_status that I can join on job_no in a one to many relationship. The job_history_status table may contain several rows of job status change dates for one job, but I only need to retrieve the most current job status change date. I've tried numerous ways to do this but am not satisfied. Any suggestions? Thanks.
Don Saluga

 

[Naith]

Go to the Report menu, Edit Selection Formula, Group.

Assuming you've grouped by Job_No, enter the following:

{JobHistory.Change_Date} = Maximum({JobHistory.Change_Date},{Job.Job_No})

which will bring back the maximum, or latest, date for each job number.

Naith

 

[DonSaluga]

Thanks Naith.
Your solution worked!
Don