I'm a relatively new access user and I have a issue I would greatly appreciate some help with. I have been asked to develop a cross sell strategy for my company. So I have established several queries and tables to show what the sales staff has currently sold their clients. I made a separate column for what has been established as the standard of what products their clients should have by industry. Is there a way to develop a formula which will identify the difference between the two current columns of information.
Ex. column (Standard) Column (Current Products) Column (needed)
DDA, IB, FX DDA, IB, FX
Need a way to automate/set up formula to bring in the third column. If anyone has any ideas, I would greatly appreciate you. Thank you very much! Jim