Hi everyone,
Can't seem to make this work...
I have a table like this:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
And I need to find the earliest invoice date per vendor:
<colgroup><col><col></colgroup><tbody>
</tbody>
Ideas?
Thanks for the help!
Helena
Can't seem to make this work...
I have a table like this:
Vendor | invoice nr | invoice date |
Alfa | 1 | 11-10-2018 |
Beta | 23 | 10-02-2017 |
Beta | 24 | 01-03-2015 |
Delta | 58 | 06-04-2016 |
Delta | 59 | 07-04-2017 |
Delta | 60 | 08-04-2018 |
Gama | 70 | 01-06-2014 |
Sigma | 91 | 02-06-2017 |
Sigma | 92 | 03-06-2016 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
And I need to find the earliest invoice date per vendor:
Vendor | earliest invoice date |
Alfa | ? |
Beta | ? |
Delta | ? |
Gama | ? |
Sigma | ? |
<colgroup><col><col></colgroup><tbody>
</tbody>
Ideas?
Thanks for the help!
Helena