Sorting Tables

I have built an Access Table with a VB interface to it. The interface will display all the records in the table, what I'd like to do is sort the table through the VB interface to display all the computers in one location for instance and exlude all records that dont fit the search criteria.

[Ravi Kiran]

Could you recheck your question?!!
"...display all the computers in one location for instance and exlude all records that .." I am foxed!!??!
------
For sorting, you can use Sql based record sets.
Create record set using SQL and then bind it with your interface. Sql provides a really wide variety of choises. so please look into MSDN or VB help for detailed info as to how to use it and what it can do

Ravi Kiran

Life is a comedy for those who think and a tragedy for those who feel

[chem1]

1)Put a text box in your form so that you can find the Search String(in this case "COMPUTERS") there
2)Use the following command:
SQL="Select * From[TableName] Where [TableName].[FiledName]"
SQl=Sql& "'"
I hope this works.If it does not then mail me I will send you ther original code(i do not have it with me at this moment)
Kamran