Hey, i am having trouble with a project i have for school. The problem is as follows:

I have one database(access), and it contains the specifications for 3 PC's( will be more but not atm), i have added a column stating the specification of the pc. I have an adodc control to display the data but i dont know how to search and sort the database on the specification field(high, med, low) that the user selected and then display the results.

If somone could suggest code and any method to do this it would be much appreciated

thanks, andrew

Try to implement the logic by SQL

Try to implement the logic by SQL

what kind of sql code should i use? i have tried using a query, but so far no success! :(

can u kindly post your table structures for my reference please.

can you please post your coded query here so i can help...