I have a report that runs off of a crosstab query. The three column headings from field SETSTAT are "cancelled" "closed" and "pending" The issue is that sometimes a company wont have any "cancelled" or otherwise, but since "cancelled" is a...
I have a report that runs off of a crosstab query. the column headings are "purchase" and "refinance". I want to have a total column next to that, if purchase or refi column equals zero, the report leaves it blank and
=[purchase]+[refinance] will not show anything. I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.