thenigerian
03-03-2004, 11:33 AM
I have an access database set up on my site and i have data storing correctly but now the problem is retrieving this data in the form of results.
now i changed the and/or option from "and" to "or" and now i can see the resuts stored, the ony issue is that all of them come out at once.
how do i a)Arrange the criteria so that these results will come out when they are strictly refered to and b) set up the search form so that i have a one line search form with a drop down box with the options for the search to be carried out for, some thing like:
search for ********** #########
******** = drop down options box, containing options.....e.g., name, address, etc.
######## = one line Text box.
The fields in the results table are as follows:
Phonebook Registration Form
Sex, Title, First name, Middle name, Last name, nickname, Age, Phone no., Phone service provider, Handset make, Handset model, Email address, Address.
Thanks.
Goodluck Okonko
now i changed the and/or option from "and" to "or" and now i can see the resuts stored, the ony issue is that all of them come out at once.
how do i a)Arrange the criteria so that these results will come out when they are strictly refered to and b) set up the search form so that i have a one line search form with a drop down box with the options for the search to be carried out for, some thing like:
search for ********** #########
******** = drop down options box, containing options.....e.g., name, address, etc.
######## = one line Text box.
The fields in the results table are as follows:
Phonebook Registration Form
Sex, Title, First name, Middle name, Last name, nickname, Age, Phone no., Phone service provider, Handset make, Handset model, Email address, Address.
Thanks.
Goodluck Okonko