Sort By Using Two Criteria

  • Thread starter Thread starter Karl Burrows
  • Start date Start date
K

Karl Burrows

Hi!

I have a form that needs to be sorted by one field and them another (in this
case sorted by neighborhood first and then by address). I used
tblLotInformation.Village to get the first sort in the Order By property,
but can't figure out how to add another sort criteria to the form.

Any help would be appreciated. Thanks!
 
Karl

I would recommend not using the Order By property. Instead, you can
base your form on a query with the sorting done in the query. You can
do this either by saving a query with the required sorting, and then
entering the name of the query in the Record Source property of the
form, or you can write the applicable SQL statement including an ORDER
BY clause into the Record Source.
 
Thanks! I just figured out the same thing! I ran a SQL query and added all
the form fields and then setup my sort.

Karl

I would recommend not using the Order By property. Instead, you can
base your form on a query with the sorting done in the query. You can
do this either by saving a query with the required sorting, and then
entering the name of the query in the Record Source property of the
form, or you can write the applicable SQL statement including an ORDER
BY clause into the Record Source.
 
Back
Top