In this tutorial you will set a group view for loans greater than $270,000 that closed in 2009.
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/09 and 12/31/09
Getting Ready to Use the Query