Problem with adding dates

[winterh]

If I give you an example of my problem and what I need to do and hope you can help.Client 1, has three ongoing cases as soon as one of the cases is closed a date goes into a field called "case1" and the same thing could happen for the other cases as well but with dif dates into "case2" etc.What I need to happen is some type of query then report which shows a number of cases which have a changed per month. eg Client 1 case1 01/05/12 case2 02/04/12 case3 01/05/12 Client 2 case1 03/05/12 case2 12/04/12 case3 06/04/12What I want to see in the report is May 3, April 3Hope you can help

[alansidman]

I'm sure that you could set the criteria for each of the cases using the Between operator. However, based upon how you have presented your issue, it appears that you may have a normalization issue. I believe that you should have a field called case and in it you would list the case nr. You would then have another field for the date, perhaps somethign like closedate. In this manner, you could query the the case field for not null and the closedate using between operator.