Write a Query or Report in Access that will avoid repition
Posted on 2011-10-03
I have attached a simple MS Access Database that has three tables, a query and a report. The report is linked to the query.
When you run the report (just by double clicking on it), you see that the email field will have data that repeats itself for every unique phone field. How can I re-write the query that will not repeat the email data for every unique phone number? Or maybe I have to make some amendments to the report to avoid the repitiion?
Any help will be appreciated.