There are many different types and ways to run queries that your Microsoft Access database application provides and one useful ms access query is where you can create a distinct or unique value list from duplicate or repeating values from other records. Check out this 4 minute video tutorial which clearly explains two ways to create a unique value query report. As the video shows, you can use either the property sheet to select unique value or the SQL statement approach […]

Tags: building distinct list in access, how to find unique values in a query, microsoft access queries, ms access queries, using distinct in your queries