How to Write a Select Distinct Query in Access 2003
Microsoft Access 2003 is a database application included with Office 2003. A "distinct" query is a setting used on your database functions that ensures each record returned is unique. This is beneficial if you want to clear out any duplicate records in a query. You create a distinct query by creating a basic query using the Access designer and setting its properties to "distinct."
Other People Are Reading
Instructions
-
-
1
Click the Windows "Start" button and click "All Programs." Click "Microsoft Office 2003," then click "Microsoft Access" to open your database software.
-
2
Click "File," then click "Open." Double-click your Access database file to load it in the software. Click "Queries" to view a list of queries. Right-click the query you want to set as "distinct" and select "Design View." The query opens in the Access designer.
-
-
3
Click the "View" menu item, then click "Properties." A properties window opens with several sections. These sections are the properties you can set for your Access queries.
-
4
Click the section labeled "Unique Values." By default, the value is "No." In the drop-down box, click "Yes." This sets your query as a "distinct" query, so only unique rows are retrieved. To test the setting, click the "Run" button. Your database records show in a datasheet, and each record is distinct.
-
1
