Query Tutorial

In this tutorial you will set a group view for loans greater than $270,000 that closed in 2008.

This query has the following parts:

·      Fields = Loan amount and closing date

·      Operators = greater than and between two dates

·      Connectors = AND

Final Query = Loan amount is greater than $270,000 AND the close date is between 01/01/07 and 12/31/07.

More:

Getting Ready to Use the Query

Creating the Query