need help sorting

crich21

Registered User.
Local time
Today, 10:41
Joined
Jan 10, 2003
Messages
97
Please help,

I have a subform that displays data from a table that I need to sort in two fields. First I want to sort the data to be displayed by the "current" field then sort by the "name" field next. How would I accomplish this. Is there some vba that I need to write and if so please be as specific as possible being I am new to the vba code.

Thank you for your reply.
Chad Richards
 
Sort the data in a query (using the "sort" option).

This will then carry through to your subform.

Note: Sorting in a query will not carry to a Report. You will have to use "Sorting and Grouping" within the report to do this.

HTH

Brad.
 
how

in a query when I try to sort two fields it sorts one then sorts the other but when it sorts the second field the first one is no longer sorted.
 
Thank You

I figured it out now. It sorts in a first come first serve basis so I had to swap the two fields in the query to produce the correct results. Thank you very much for your time and help.
 

Users who are viewing this thread

Back
Top Bottom