We are now going to create our sorting buttons. Do this for each of the fields you would like to sort. We then want to use a different SQL string based on the button that is clicked. The easiest way to wite SQL is to have Access write it for you. If If Request.
Lets move on to searching the database.
To do this, we want to decide which fields are able to be searched, in this example we will be using all of them. To sort the searched records, you can use a flag to determine if the table has been searched through yet. Adding, Deleting, and Updating Records in a Database. Copyright 2001 INT Media Group, Incorporated. All Rights Reserved.