Table Sorting Problem

[vikoy]

I had this button in my form and upon clicking on it the Recordset on the grid sort the names field in ascending order. The problem is that is does not reflect the actual table in Access upon sorting the recordset. I've wanted to reflect the changes made in the recordset and the table as well. This is the basis of my data report, changes in the actual table.

TIA.

[parksie]

Sort order in the actual table is usually irrelevant, because for reports, tables are interchangeable (up to a point) with query recordsets.

[vikoy]

Hi again,

Can you give me an example of it? Because if I have three fields to sort in a table then I will generate three kinds of data report. if the actual changes on the recordsets reflect also in the table, then I will only produce one kind of generic data report. I would to minimize of creating three kinds of commands in the dataenvironment and data report with only one command and data report.

I'm new in VB . please help....

[parksie]

This should work to use Surname as the primary sort and FirstName as the secondary sort.

SELECT Surname, FirstName, PhoneNumber FROM People ORDER BY Surname, FirstName