I have a table in a database named "tblstudentnumber" it has the following columns:
stud_id
stud_fname
stud_lname
stud_address
stud_age
stud_course
i need to have a data report using data environment that can sort all students with the age(a user input) of let say "16".
i have a form, it has a textbox named "txtage", i have a button "search" and a button "print". if i entered 16 in the textbox and if i clicked "print" it will print all data in my table with the age of 16, if i input 17 it will print all data in my table with the age of 17
what is the right sql in the properties of the data environment??
thanks in advance...