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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by g83man

  1. g83man

    can I search all fields in db in one query

    Sorry about not replying but I thought I had put the query in the wrong forum. I'm new in the tek-tips forums and I didn't mean to ignore your help. I can see what your getting but I'm not that experienced at SQL and don't know how to input a parameter. Can I do this from within a form? Thanks...
  2. g83man

    Query to search all of the database

    I need to set up a query that will search all of the fields in a database for a specific item. could be a date name number or description etc. just like the find facility in Excel. I would like to run this from a form regards
  3. g83man

    can I search all fields in db in one query

    I have a database with 15 fields which contain names refernce numbers dates descriptions etc. Is it possible to just enter 1 parameter and search all of the fields. The para could be a name number or description if you see what I mean , it needs to be like the find function in Excel. thanks

Part and Inventory Search

Back
Top