0
Reply

CheckBox and Querry

guy

guy

Mar 17 2006 4:16 AM
1.7k

Hello,

I want to create an SQL querry that will check if several Checkbox are checked,
and if they are, performes a specifiec query.
for Example:
children names: 1.Guy 2.Donna 3.Kerry
Children studies: 1.biology 2.computers 3.history

lets say i've checkd "Guy" "Donna" and "Computers"
the query will make a selection where the name is
"Guy" or "Donna", and where studies is "computers"

(btw, I work with an access database ,
connects c# with microsoft Jet)

the problem is that I need first to check if the specific checkbox is selected
and only if it is, to make the query with a changed variable, How?

thanks in advance,
guy