SQL statement

[niki]

easy SQL statement problem

hello,
I need to filter data which gives a reliability grade for an entry ([Customers].[Fiabilité%]). I wanna do this by using a combobox which, if selected, will interact on the data shown as all the entries with a reliability grade under 50 will disappear.

Here's the code but I am doing something wrong!!!

SELECT DISTINCT Customers.[Entreprise Cliente]
FROM Customers
WHERE (((Customers.[% Fiabilité])>=[Forms]![frmFilter].[filter3]))
ORDER BY Customers.[Entreprise Cliente];

How can I have, when clicking on the combobox, a fifty (50)appear which would make the user understand that he's going to filter the data, and when I run this filter have only the entries with reliability field higher than 50?

thx to anyone who can help

One more thing how is the filter gonna know which value to take in order to remove the entries whose [Fiabilité%] value is less than 50 for example??? Where do I input this value in the properties of my combobox? in source control?
Can it be that I Access doesn't know that the type of data is numerical????

cheers
nico

 

[AncientOne]

see my combo box example

 

[niki]

yeaaaaaaaaaaaaaaaaaaaaah

Thanks got your zip file!!
for anyone interested the problem is solved here

cheers!
nico