Hi guys, i'm a rookie when it comes to access. My delima is my boss need someone to run some queries for him and since no one has any knowledge of access I was given the responsibility of meeting his needs. What he wants sound simple however as I mention earlier i'm a rookie at this. We have a number of files, each file is broken up into (accounts, sbu, agreement #, amount dr and cr). The query that i'm responsible for creating is suppose to bring back this information. Matching account, sbu agreement # and offsetting debits and credits. After that the remaining items that are not paired off will be considered true exceptions, and thats what he wants the total exceptions. Any help is greatly appreciated.
Thank you in advance
ewart
Thank you in advance
ewart