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

megatronixs

Registered User.
Local time
Today, 01:05
Joined
Aug 17, 2012
Messages
719
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.
 
Last edited:
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
 
Use the Max() ( function instead of Min
 

Users who are viewing this thread

Back
Top Bottom