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!

Register Log in
  • Congratulations TouchToneTommy 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: *

  • Users: mdsoren
  • Content: Threads
  • Order by date
  1. mdsoren

    Setting SORT BY

    I have tried to search the forum, but don't see anything like what I am trying to do... I have my SQL statement built on the fly based on values selected from 5 combo boxes users may choose as many or as few, but at least one. No matter which elements they are searching the database for, the...
  2. mdsoren

    Create a SELECT query based on user input

    I have been hunting for a solution for this for two months and have yet to find it! I have a VB application which allows the user to select one, any combination or all five variables to search on (Owner's name, Attorney's name, State, Company Type and Accounting Firm used). The report to be...
  3. mdsoren

    Create a SELECT query based on user input

    HELP!!! I have been trying find a way to create a SELECT query at runtime based on the user selecting values from five combo boxes. They must select at least one, but may select any combination or even all five. The data comes from a hierarchy of tables. My table structure can be one, two or...
  4. mdsoren

    Set up "WHERE" criteria on the fly

    HELP!!! I have been trying find a way to create a SELECT query at runtime based on the user selecting values from five combo boxes. They must select at least one, but may select any combination or even all five. The data comes from a hierarchy of tables. My table structure can be one, two or...
  5. mdsoren

    Help with UNION

    I have an app which allows the user to create their own search criteria (by selecting from any or all of 5 fields). The selections they can make come from values in combo boxes, so they can only search for data that pre-exists. I have built an individual SELECT query for each searchable field...
  6. mdsoren

    Help with JOIN (or UNION?)

    I am a real "green horn" when it comes to writing SQL statements. Can anyone help with what I see as a difficult JOIN query? I have 5 different fields users can select a value in to build their search query. They can choose 1 field, all 5 fields or any combination in between. Given...
  7. mdsoren

    Nested query, sub-query, join or what?

    Here's my problem - I need to build a single recordset from multiple tables based on the input of one record ID. Given this ID I pull the "main" record from table one, search tables 2, 3, and 4 for linked records based on the ID already provided. Upto here I am fine and have the...

Part and Inventory Search

Back
Top