Changing sort order in a related field

[jaybutler1234]

I have a database that shows name and date enrolled.

The names are in one table and the dates in another. When I do a report the date field shows the earliest date for each name. I need it to show the latest date.

Thanks

[Fitch]

You could either create a sorted relationship (sorted by date, descending) and use that date field on your report layout, or you could use your existing relationship, but put the date field inside a one-line portal, and sort the portal.

Another option is to create a calculated date field: Min(related::datefield)

[jaybutler1234]

Hi. The sorted relationship did the trick.

Thanks!