I have 10 years of weekly data, I need to get Bi-yearly data.
I am using VB6, and Access as my back end.
ADODB connection and recordset to query my results to data grid on form.
I also need to have the option of offset the starting/ending month of the bi-yearly data.
But we can start with getting half-year data, such as grouping bi-yearly data.