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

Search results for query: *

  1. marrah

    Newbie Question - Creating if not, then query statement

    I'm trying to create a search that looks up (1)both first and last name (I have this part already based on a qbe that works fine), but if that combo doesn't exist, will pull up (2)either the first or last name. Example: If Jane Smith isn't in the table, it will pull up Jane Smyth, Jayne Smith...

Part and Inventory Search

Back
Top