I have a table in a database named "tblstudentnumber" it has the following columns:
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...