oder by field

[Maritza]

Please tell me how can I create a querry in access 2002 where the results are
ordered by a specific field. I need to create a mail merge document to print
a thank you letter every time I enter a payment.

 

[Rick B]

While in query design view, you see that drop-down under your column called
"sort"? Click it.
This will allow you to sort in ascending or descending order. If you need
to sort by multiple fields, put the primary sort first, then the subsequent
sorts.

If you are simply creating *A* thank you letter *EVERY TIME* you enter a
payment, I would expect there to only be one record though, and I would pull
the details from the form where I entered the payment and place them in a
"report" that I could print. (If it were me)


Rick B