I have a report that needs totals. I have all of them except one. The information came from an Excel file and one of the fields consists of the letters "Y" or "N". In the footer I need to be able to separate the Y's from the N's and have a total for each. All the expressions I have tried haven't worked. I can get a grand total but not individual ones. Is there anyway to distinguish between the two and get a total for each ?
thanks a bunch
Taylor
thanks a bunch
Taylor