Not sure how to construct this query
Posted on 2012-03-29
My problem is this: we have a ton of agent commission data in flat files and we are in the process of outsourcing a conversion. Unfortunately, because we don't have any relational data there is no way for them to piece together commission hierarchies. So it's up to me to reconstruct them, and I'm a rookie when it comes to Access. There are two tables in my Access database: AGENTS and AGCOMCREV
I need a query to eliminate all the records from AGCOMCREV except for those with the field "AgentCode" matching those found in the field of the same name in AGENTS. This will reduce my dataset so I can move on to the next step and show you guys what I really need to accomplish.
Thanks for your help!