only show the last dates

[AnneV]

I explained my problem is attachement with print screens

 

[theDBguy]

Hi. Welcome to AWF!

Have you tried using DMax() maybe?

 

[AnneV]

Hi. Welcome to AWF!

Have you tried using DMax() maybe?

When putting a D in front I get the message: "the expression you entered has a function containing the wrong number of arguments"

 

[Gasman]

Perhaps lookup the syntax?

Application.DMax method (Access)

Office VBA reference topic

learn.microsoft.com