extracting 1 record per query based on timestamp
Hi,
I am struggling with a query the is returning too many records for a determined key.
Record is
[Person], [keyType] [createdTimeStamp]
so, most of the time I have only 1 record per person but, here and there, I may have 2 and mor records, for different keyTtype]. I need the extract on the query , just the very last record baased on [createdTimeStamp
any ideas?
I am struggling with a query the is returning too many records for a determined key.
Record is
[Person], [keyType] [createdTimeStamp]
so, most of the time I have only 1 record per person but, here and there, I may have 2 and mor records, for different keyTtype]. I need the extract on the query , just the very last record baased on [createdTimeStamp
any ideas?
Last Comment
ASKER
Welll... this a bit of a strecth because only some of the records are "doubled".... Will let you knwo...
Well I think it should pick the top record whether there is one or ten.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
https://www.google.com/search?rlz=1C1GCEA_enUS887US891&ei=Rpq5XoaVM8rUtQXN-I3YDQ&q=microsoft+access+top+value+query&oq=microsoft+access+top+value+query&gs_lcp=CgZwc3ktYWIQAzIGCAAQFhAeOgQIABBHOgIIAFDMJVjLUmDOVmgBcAF4AIABeogBwAqSAQQxMi40mAEAoAEBqgEHZ3dzLXdpeg&sclient=psy-ab&ved=0ahUKEwiG0M2SuazpAhVKaq0KHU18A9sQ4dUDCAw&uact=5#kpvalbx=_a5q5XsDCGISksAWNjbuQDg40