I was wondering if anybody has some ideas. i need to create a report that
has three years of history. it is hard to describe the entire project, but i
will describe it breifly.
the user enters a date range (usually would be jan 1 until some date within
the same year). i then want to show the data for that date range in the first
column, and then the past two years in the next two columns. the problem is
that the underlying query is different for each of those columns. to be a bit
more specific, for year 0 i need to split the data based on the date range
and in year -1 and year -2 i need to have a different query per year.
i would love to write all this in VBA, however, a report needs to have be
bounded with one and only one recordset. i know that in DAO i was able to
create at runtime a querydef that would maybe help. however i use only ADO.
this last part i am not sure makes a difference. basically what would be
optimal for me would be to some how attach a recordset to each column.
anybody saw anything resembling this, i would be happy if you share it.