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 strongm 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. toyshoppe

    Duplicate Records in a filtered query

    Rick, Your 3rd paragraph hit the mark. I'm only using to the result for the product id. I tried DISTINCT, but it requires that I include all of the fields that will be returned and if I filter by category I have to return that field and therefore DISTINCT will produce multiple rows, one for each...
  2. toyshoppe

    Duplicate Records in a filtered query

    I'm trying to construct a subform selection list for a group of products that needs to be filtered by control on the parent form. The problem is when I include the Category field in the subform's query it creates a product id row for each category it belong to. What is the best way to...
  3. toyshoppe

    Filtered and unfiltered Query

    Could I take this thread a little farther? I've had the same problem putting a variable into a LIKE criteria. Your solutions work great... except for a query field that is a primary numberic key. It appears that a LIKE * does not work on numberic fields, is this true? Jay

Part and Inventory Search

Back
Top