Microsoft Access 2007 tutorial:unique values and top values


Unique Values and Top Values

III. Select Query(Cont')

Select query can be used to retrieve data in more complex ways. For example, you can use the select query to get no duplicate records or you can get a number of top records.

III.3. Retrieve no duplicate data

To retrieve no duplicate data, you have to set yes to unique values property of query.

Microsoft Access 2007 unique values property

Note: To show the property sheet above, you have to click property sheet on the ribbon or press F4 or Alt + Enter.



III.4. Retrieve Data with a Specified Number of Rows

You can specify a number of rows by setting the number to the Top Values property. How many rows do you want to show? For example, you want to show 5 records.

Microsoft Access 2007 top values property


Comments

CAPTCHA image



This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.