New
#11
One of the most important things with Access is getting the basic design right. It is actually better to have too many fields in your main Table than not enough.
In the OP's case having a phone number field would have made this a very simple operation, as the phone number would have been unique for each customer, so when running a query, typing "No Duplicates" in the "Criteria" section of the phone number field in the query would return just the one customer per phone number & multiple listings for each customer would be avoided.
Also the query could be saved & run again at any time that a new mailing list was needed.
Last edited by Ranger4; 08 Feb 2014 at 00:17. Reason: Needed clearer explanation.
Quote