Jumbled up in select query(input by user)

  • Thread starter Thread starter nt_deepak
  • Start date Start date
N

nt_deepak

Guest
hai,

my problem is that i want to see the details of the select query and the selection is done by the help of values provided by the user.
eg.

select * from student where stud_name=" here i want the value provided by the user in ms-access".

thanks...

deepak
 
if query criteria is from a open form
select * from student where stud_name=" &"""" & forms![yourformname]![controlname] & """"
 

Users who are viewing this thread

Back
Top Bottom