Show highest Value

[Taff]

Hi all,

I have a table with several records and I am trying only to show the one with the most recent date.

Thanks

Ant.

 

[maxmangion]

create a query, and sort it by the date field in descending order, then in the query properties find the option "Top Values" and set it to 1.

 

[Taff]

Hi maxmangion,

Sorry I explained the situation wrong.

I have two tables in my Query - tblLearners and tblActivities. One Learner can have many activities.

What I would like to do is show the Learner and only the one activity that has the greatest date.

Regards,

Ant.