Good afternoon all.
I am a new user of Kexi and I have created a simple database used to show pictures of the items we list in the offer to our customers. In the Table there are four fields (excluding the Primary Key): Description, Position, Selected (Yes/No), Image. I made a Query that should allow me to "see" only the items selected as "Yes" and order them ascending according to the "Position" field. No problems in ordering them, but I cannot set the criteria: I have tried to write it in SQL but I am not able to find which word after WHERE is correct for making it work.
Thank you in advance for your help.