I have a table with the fields: dDate and Value
The table has numerous records spanning many years
I need a query that will return the first and last date for each year.
e.g
1/1/2016
15/11/2016
4/2/2017
30/12/2017
3/1/2018
30/11/2018
How do I do this?
Thanks in advance
The table has numerous records spanning many years
I need a query that will return the first and last date for each year.
e.g
1/1/2016
15/11/2016
4/2/2017
30/12/2017
3/1/2018
30/11/2018
How do I do this?
Thanks in advance