I have a fairly complex crosstab query that is used in a report. I have dynamic column headings based on input from the user when the report is ran. Basically the report shows me the number of orders a customer had per month. I have the report setup so if the number of orders declined 1-4 from previous month it would turn that row yellow. If the cutomer's orders declined 5 or more, then it turns the row red. If the customer has not used us in over two months, it will turn the column orange. I need to be able to total up the number of yellow, red, and orange customers. I can't seem to get the counters to work for this. I had placed them in the same code that turns the record the appropriate color, but it doesn't work. It keeps reseting the counts when it gets done running through the code. I then discovered the wonderful feature regarding retreat event. How do I get around this problem and get my totals that I need? I want to place the totals in the footer of my report.
Microsoft Access 2003 interface with a SQL 2008 database.