need help sorting

[crich21]

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

 

[bradcccs]

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.

 

[crich21]

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.

 

[crich21]

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.