Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Searching a database in MS ACCESS
Jonathan,<br><br>Use a parametric query. In the criteria row of each of the fields you want to search for, type in something surrounded by [ ], for example...[Enter a qualification]. When the query is run, the user will be prompted to enter a value and this value will then become the actual...- AoxomoxoA
- Post #7
- Forum: Microsoft: Access Other topics
-
Access 97 - Instr in a Dlookup
No problem<br>First create a query which has the Instr function as a calculated field. Then use DLookup on the query using this calculated field in the criteria argument(the third one)- AoxomoxoA
- Post #2
- Forum: Microsoft: Access Other topics
-
Searching a database in MS ACCESS
Jonathan,<br><br>Not sure what exactly you mean by multiple fields in the database, I am presuming that you have a single table which contains repeating field information as in the following structure:<br> Person(PersonID, Qualif1, Qualif2, Qualif3..)<br>An example record...- AoxomoxoA
- Post #2
- Forum: Microsoft: Access Other topics
-
How to get value from a table for calculation in forms
Hi tintin007<br><br>I have used the DLookup function very often and it's a truly powerful function. <br><br>There is yet another solution...<br><br>Since the user has to select the country id from the tax table anyway, why not have a form(pop-up or otherwise) from which the user can select the...- AoxomoxoA
- Post #4
- Forum: Microsoft: Access Other topics
