Keep only 1 record with the Newest date

[yomero]

Hi,

I have a table with a list of users. Currently there are duplicated users since the records are from different dates.

how can I tell the query/criteria

if userID >1 then
keep only ONE
with the newer DATE

Thank you

 

[Joe4]

Please provide the names of your table, and your user id and date fields.

 

[Marbles]

In a Query, you could group by UserId and have the Max of Date.

 

[Marbles]

If you still need UserId >1, add another field, Count of UserID, with >1 in the Criteria line.
All of these in a Totals Query.

 

[yomero]

Thanks, I followed your suggestions and it works.

I have another question:

I have 3 columns
- Application (it contains multiple applications, and accepts duplicates)
- Date
- Number of users (it displays the number of users per application per day)

I created a TOTALS Query and asked to show MAX value of numbers of users.
How can I get the Date of that MAX value?

Example: MAX Value for Application X = 97%...if I dig in the Data table I find it in January 15, 2015....

Expected result
Application 1 / 97% / January 15, 2015
Application 2 / 85% / February 5, 2014
Application 3 / 25% / January 10, 2015

Thanks.

 

[Joe4]

I created a TOTALS Query and asked to show MAX value of numbers of users.
How can I get the Date of that MAX value?

Link your Aggregate Query back to your original table, linking on the User and Value, and then you can pull the date of that record.