Unique or Distinct Values in Queries Access
Often queries that we have designed return many rows with the same data. It often makes sense to set a unique setting equivalent to the SQL Distinct keyword on the query. It's found in the properties sheet of the query under Unique Values. Just set this property to yes. This will avoid duplication of results and give a clear one record per hit result set.
Watch video Unique or Distinct Values in Queries Access online without registration, duration hours minute second in high quality. This video was added by user Q Visible 27 January 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 41,093 once and liked it 126 people.