Recent content by wcelenski

Count all letters separately, and then create a sum formula summing all of those, or weeding out whatever records you feel you don't want/need.

I've been thinking about your problem and I may have came up with a start to a solution. Have you tried grouping by Contract and then Status. That would give you something like this, respectively: Contract 1234 Status 1 Status 2 You can then write a series of suppression statements in...

I would recommend using a Running Total. The reason is because you can choose the field you want to summarize, and use a formula on how you want to evaluate each record. You can also choose if you want to reset the total, if ever. It is a very easy and straight forward method of...

Do you want every transaction in the entire report to have Status = I? Or, do you only want to use it for these two transactions you speak of?

I understand that this is not a common inquiry because sums are generally displayed in the latter part of the report. Group footers, report footers etc. My current situation is unique, however. At least to me it is. In an attempt to make life easier for an employee I am copying a form that...