Quantunet.com

Access QuickSkills

     

 

 

How to create a date filter organized by Grade ?

 

 

Add a new field to the Query:

  • Click on the "Design view" icon.

  • Scroll down the Alumnos window, select "Grado" and drag into the Fifth field.

Sort the field data:

  • In the Grado column click on the "Sort" cell then choose "Ascending" from the drop down menu.  

    (This will sort all the grades into ascending order)*.

View the resulting query:

  • Go to the main menu and press the view button.

 

*The query presents the data organized into ascending order of grades. Sorting the results is only a superficial modification to the database. When creating Reports from this Query you can resort the data.

© 2006 Quantunet.com All Rights Reserved
 Terms of Use