Limit by earliest date

[kattlees]

I have a column that has customer id and date

entries would be like:

Customer                              NoteDate

123456                                  12/15/2017

123456                                  12/18/2017

123456                                  1/01/2018

654321                                   1/05/2018

654321                                   1/06/2018

I want to limit the table to just the earliest date for each account so the above would be:

123456                                  12/15/2017

654321                                   1/05/2018 

How do I do this in edit queries?

[Vvelarde · Accepted solution]

@kattlees

Hi, How are you?

Ok. Let 's go to solution in Query Editor

Regards

Victor

Lima - Peru