- Joined
- Sep 6, 2011
- Messages
- 1
- Reaction score
- 0
hi all
new to forum as well as to Access. I have created a small database and have a form to add, view and edit records. but i need to query the table based on the user input
I have a form , i will have a text box and if the user types a name and press the button , it has to fetch set of records , in the form of report
the basic sql will be like this
Select Memberno, Firstname, Secondname, role, Meetingno
from Meeting
where memberno = 35566
in the above query the value 35566 will be input by the user
can you guys guide me how to achieve this ?
new to forum as well as to Access. I have created a small database and have a form to add, view and edit records. but i need to query the table based on the user input
I have a form , i will have a text box and if the user types a name and press the button , it has to fetch set of records , in the form of report
the basic sql will be like this
Select Memberno, Firstname, Secondname, role, Meetingno
from Meeting
where memberno = 35566
in the above query the value 35566 will be input by the user
can you guys guide me how to achieve this ?