Well, it wasn't very clear from your question if you were using a report expression or a SQL Select or working in a program, so I tried to give a generic answer.
If you make a report expression be equal to something like:
iif(mydate < yourdate, 1, 0) and click on SUM under calculation, then it will add a 1 to the value of the expression for each record in the report where the condition is true.
If you use count, then it will just count every record, no matter what is in the report expression. As a matter of fact, I usually use 12345 as my expression when I am doing a count, just to make sure there is room for all five digits.
>Hi Todd,
>
>Thanks for the response. Do you mean create a field in the table containing the value of 1 and summing that instead of using Count. I thought about that but not very seriously. I should give it more serious thought. Thanks.
>
>Regards,
>
>Paige
--Todd Sherman
-Wake Up! Smell the Coffee!