Reporting Semi annual series

[legalkill]

I need to report a series of records through two time ranges. I need a semi annual report (only 6 months) that will report in a monthly group values from 12 months prior. For example the December month group i need to have the subset of records from Jan to December. Then the November report would include December of previous year till November.

I can separate records using the between statement and the Date-days. "Between [date] and [date]-365" I can get the 12 month group from any date. How do i then specify a 6 month (semi-annual) grouping that repeats the 12 month series over that 6 months.

 

[Lightning]

If I understand you correctly, you have a report that Groups by 6-Month periods and then, within that 6-month period returns a 12-month value for each of the six months.

If this is correct, then for the 6-month group parameters, you can Group using the Month function to set your parameters:

Between (Month(Date())-6) and Month(Date())

HTH

Lightning

 

[legalkill]

I need a report like this:

Jan 2001 (Group)

1/1/01 333 (detail of only 12 months before the group month)
2/1/01 123
3/1/01 213
4/1/01 121
5/1/01 345
6/1/01 356
7/1/01 567
8/13/01 784
9/12/01 843
10/1/01 592
11/30/01 423
12/1/01 534
Groupsum 10044
---------------
february 2001 (group - same for 6 months)

2/1/01 123 (same as before except on month later)
3/1/01 213
4/1/01 121
5/1/01 345
6/1/01 356
7/1/01 567
8/13/01 784
9/12/01 843
10/1/01 592
11/30/01 423
12/1/01 534
1/4/02 667

The data is just a simple table of date of entry and a value for several columns. I can make it return a value 12 months from a date (the detail part) I can;t separate and repeat for hte 6 Month group.

 

[legalkill]

Just in case anyone wants the answer. I used a subreport and a separate query to create the 12 month series based on the date from the report. (between report![date] and report![date]-364) The main report is based on dates that are grouped by month with a month header and based on a query reading the dates form a table of semiannual values (i use to query all semi annual tables)

the only thing that i cannot do now is have a report footer in the sub report that sums the data values. When i did this it stopped the date from being properly read from the main report, resulting in the sub report being the same and not reading the descending date form the main. i took out the sums in the report footer of the sub and it worked again.