Recent content by VABlitz

Thanks for the help. I thought of a workaround to the problem. I changed my SQL Query to not label those two fields. While this creates a blank spot to appear above my Totals, it is the easiest option. If only I would have thought of this 24 hours ago

On second thought my solution fixed it in the body, but my totals for RMA open and closed are gone from the total section.

Nevermind found a different solution. Changed the Filter to read: Equipment <> "Open RMA" And Equipment <> "RMA" and turned the Filter On to Yes

Per your suggestion I tried this: Iif([NumberTested] is null, [Equipment].Forecolor = 16777215, [Equipment].ForeColor = 0) but instead of the data that is in [Equipment] changing color, I received a -1 or 0. Did I enter somethine wrong?

I have a report based on a query with 3 fields (Tested, RMA, OpenRMA) The query searches all the tables in my database and gives me a count of the equipment tested, RMA reported and open rma. The report has two fields (Equipment, NumberTested) with a total below and also a total of the RMAs and...