Forums

This topic is locked

Sql..........HELP!!!!!!!!!!!!

Posted 26 Jul 2003 20:54:39
1
has voted
26 Jul 2003 20:54:39 paolo titolo posted:
I made a form for a query where you can select the eyes color ,associated to a value (blue=1, green=2, nero=3)
I will like to include all the values in case the list is not selected
I tryed to associat a neg value (as many people do (-1)) but I don't know how to write it in sql
I use Ultradev recordset
I need somethig like:

SELECT *
FROM table1
WHERE (if the value of the form is >1 then eyes = to the value of the form else il the value of the formi <1 then thake all the valuesof eyes > di 1)

i don't know how to write itin sql...
Maybe the are other ways to get it..
thanks
if it can help I send the photo of the recordset

Reply to this topic