2nd ORDER BY in form fields

[an]

Hello!

In Form, I have a Field1 with ORDER BY and work fine to
this field, but I would like to apply 2nd ORDER BY to 2nd
field too (Field2).
With ORDER BY in Field1, logically, isn't order the Field2.
Away the Table is ordered by Column1 Field1 and Column2
Field2.

Now, in Form, the order is:

Field1 Field2
1 C
1 A
1 B
2 B
2 A
2 C
3 B
3 A
3 C

I need:
1 A
1 B
1 C
2 A
2 B
2 C
3 A
3 B
3 C

I don't know to obtain this in Form. Therefore, any help
is welcome.
Thanks in advance.
an

 

[Dave Peterson]

Any chance you're writing about data on a worksheet and the Data|Sort dialog?

If yes, then you can have a secondary sort key and include that with your sort.