How to avoid the records from doubling?
I have a very simple scenario.
In table 1 I have records displaying account numbers and the dates in which these accounts were contacted. There are multiple records for the same account number as there must of been multiple contacts.
Acct2 ....... and so on
In table 2 I have data related to the sales lines for the whole month of July.
With my current selection the sales lines records are doubled or tripled etc. based on the number of times the same record exists in table 1.
How do I refine the selection criteria to look at the table 1 and display records from table 2 only once?
Both tables are joined by the Account# field.
Any help would be greatly appreciated!