Filter values in database

[topsykretts]

Hi there. I am looking for someone to explain how to filter a ms-access database by column and display only cells which have higher values than given value from textbox?

Example: If given value in textbox is 3:
Column1
1
2
3
4
5

Filtering...
Column1
4
5

 

[IanRyder]

Hi,

Have a look at this SQL tutorial on the WHERE clause:-

SQL WHERE Clause

Hope that helps.

Cheers,

Ian

 

[topsykretts]

Hi Ian, thank you for the reply. I late with reply I am sorry, but I don't know how to use SQL. I have imported database.

 

[jmcilhinney]

I don't know how to use SQL.

In that case it's a bit pointless our explaining how to do this one thing when you'll just have to come back and ask how to do the next, and the next. Your first step should be to learn the basics of SQL. We can then help you with the specifics of any situation but you will have the fundamentals already so we won't have to go over every little detail every time. There are no doubt plenty of SQL tutorials on the web, for those willing to look. Here is just one example:

SQL Tutorial