Sounds simple, but the solution is escaping me.
Table 1 - "FY2011" has the following values in Field:"Account"
Table 2 - "FY2012" has the following values in Field:"Account"
What is the simplest way to automatically (script, portal, whatever) to show that "in FY2011 there was account A that doesn't appear in FY12; and in FY12 there was account E that didn't appear in FY11"?
Essentially I want to ignore the "overlapping" accounts "B,C," and call out accounts "A,B".
I know this isn't rocket surgery, but I am at a loss. If its easier if all accounts are in the same table (with separate field identifying the Fiscal Year), I am cool with that, also.