I have a database called db1 with a table call records.
I have set it up as data1 recordset.

Is there a code that will allow a sort of the table
(records). The table has mulitple fields. I want to sort
first by field1 and then by field4.

When the sort takes place will the table be permanetly
sorted so that i can print one line at a time, grabbing
each line of the table and printing it, in sorted format.

thanks
larry

No, the idea of the database is that you have no control over the
order of records within the database.

If you want it sorted then open up the table with a SQL SELECT
statement which sorts the view.

Regards
  Malcolm Smith
  www.dragondrop.com

Hi Larry,

Wouldn't something like:

    Me.Data1.DatabaseName = "d:\MyDocs\Access\db1.mdb"
    Me.Data1.RecordSource = _
"SELECT f1, f2, f3, f4 FROM Table1 ORDER BY f2, f4"

do the job for you?

Krgrds,
Perry

In fact this is the preferred way to do it.

Malc
  www.dragondrop.com

Was the reply and e-mail useful?

Regards
  Malc
  www.dragondrop.com