sir, it like searching function
i need to search the table which has data stored in ms access table. i have create a text box for the contract no,username and date and need to search the table according to contract no or username or date.
for that i need a coding with solve the problem in single sql command. i have try it with where help is a table,search-test is form.
when the help(table).cont_no(field) is equal to search-test(form name).cont_no(text box field)
SELECT
*
FROM
Help
WHERE
(((Help.cont_no)=[Forms]![search-test]![cont_no]))
OR (((Help.username)=[Forms]![search-test]![username])
or ((Help.date)=[Forms]![search-test]![cbo_date]));
hope you will understand my view