Need help creating a formula

[Jimmy0291]

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

[jzwp11]

Welcome to the forum!

You said that you have your tables setup. How you have your tables set up will determine how to setup the queries to do what you want. So, can you provide some details on your table structure (tables, key fields and relationships) so that we are better able to get to a solution?