igis
03-23-2002, 05:03 PM
I have about 70.000 records which inclouds ITEM.NAME, ITEM.DATE, ITEM.GROUP.....
I would like to display those items in a subform group by ITEM.DATE (month) and ITEM.GROUP and then sort by month. The problem is, that some ITEM.GROUP don't have any records in particular month, but I would like to display all months in the subform and also in the chart. So i would like always display a value and month in a subform like this:
ITEM.DATE ITEM.GROUP SUM
jan 030 5000
feb 030 1500
mar 030 0 ( no records in March)
--- --- ----
dec 030 2980
Please help!
Thanks in advance,
IgiS
I would like to display those items in a subform group by ITEM.DATE (month) and ITEM.GROUP and then sort by month. The problem is, that some ITEM.GROUP don't have any records in particular month, but I would like to display all months in the subform and also in the chart. So i would like always display a value and month in a subform like this:
ITEM.DATE ITEM.GROUP SUM
jan 030 5000
feb 030 1500
mar 030 0 ( no records in March)
--- --- ----
dec 030 2980
Please help!
Thanks in advance,
IgiS