Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query
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 using the keyword Distinct. In fact, an extension to Continue reading “Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query”