return only one record where dates are differnt byt 2 columns same results

[megatronixs]

Hi all,

I came across a silly thing that I can't figure out.
I have 3 almost same records, the only difference is that they have a different time (hour and minutes) in the field "created'
as you can see from below:
15/09/2017 09:25 John Secada Started 05/09/2017
15/09/2017 11:59 John Secada Started 05/09/2017
17/09/2017 09:40 John Secada Started 05/09/2017

Is there anyway to only have a query that will only show the youngest date?

Greetings.

 

[Ranman256]

make a query, qsEarliest,
turn on summation, use the MIN setting to the the earliest time of that day.
PERSON, DATE, MIN(created)
(this give you the person and the earliest record for that 1 day)

make another query,
then join the query above (qsEarliest) to your tData table,
join on NAME, to both
and qsEarliest.MinOFCreated to tData.CreatedDate

 

[arnelgp]

Use the Max() ( function instead of Min