Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 123
  • Last Modified:

Opening recordset and sorting.

Hi,

Set someTable = databaseConnection.OpenRecordset("TableName")

How can I sort the above table by a given field while opening it?

Thanks,
Uni
0
Unimatrix_001
Asked:
Unimatrix_001
1 Solution
 
Patrick MatthewsCommented:
Hello Unimatrix_001,

Have the recordset sorted on creation:

Set someTable = databaseConnection.OpenRecordset("SELECT * FROM TableName ORDER BY [SomeColumn]")

Regards,

Patrick
0
 
Unimatrix_001Author Commented:
Thank you. :-)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now