Report should display latest date only

[Dougbum]

I've had great success with my database, thanks to the help received from this Forum!
The newest glitch is when I generate a report. The report is based on two tables, one of which tracks patient visits by date. Since the date subreport is now collecting multiple visits for each patient, the report is generating multiple patient lines, each with a separate date.
I would like the report to list each patient with only the latest(most current) date. Can I set a "parameter" in the SQL table for the DATE, so only the most recent date is displayed?

Thanks for any and all help,

Doug

 

[lark_tilly]

Try using the Top Values property

In your qry, set the Top Values property to 1 and set the sort on the date field to descending. That way you should only get the most recent date record. Watch when you change the value to 1 from All. It tends to change to 100 so be sure it's correct before you close the window.

 

[Dougbum]

"Top Value" property didn't work

Thanks for your quick reply...

I tried the Top value property in the QSL table, but it seems to have effected the entire report, not just the DATE field. Now I get only one record showing on the report. The SORT to "Descending" did work however.
Is there a way to set the Top Value property to effect the specific table used to set the DATE value in the QSL without effecting the entire report?

Many thanks,
Doug