Recent content by iXm

  1. I

    SELECT Query with AND in criteria

    Your Multiple Group and Filter is an excellent example, what if I want to select the kids of age Year-7 And Year-8 And Year-9 at the same time..?
  2. I

    SELECT Query with AND in criteria

    Here is my DB attached, I am generating a database for keeping a record of aircraft maintenance engineers, which come in A, B & C categories. They need to undertake exams P1,P2,P3,P4......, more than a dozen in each category. Now what I want is a Form Query named "My Query" in my database, where...
  3. I

    SELECT Query with AND in criteria

    @cheekybuddha SELECT CAT FROM Test WHERE Product IN ('P1', 'P2', 'P3') GROUP BY CAT, Product HAVING COUNT(*) = 3; is not working! The CJL's solution in post # 4 is working but it's computationally intensive if I go for let's say 10 AND criteria! I've to build a query on form with...
  4. I

    SELECT Query with AND in criteria

    What if I want to go for additional criteria such as "P1" And "P2" And "P3", do I need to have another table named "C"..?
  5. I

    SELECT Query with AND in criteria

    I did it by pasting your code in SQL View, it works! Can you explain, how to do it in Query Design..?
  6. I

    SELECT Query with AND in criteria

    No, I don't want data to be editable
  7. I

    SELECT Query with AND in criteria

    Absolutely "YES"
  8. I

    SELECT Query with AND in criteria

    I didn't get you?
  9. I

    SELECT Query with AND in criteria

    I am new to MS Access! I have a Table, with products and their categories. Each category (CAT) may have no product or multiple numbers of products. Now, I want to search for category which is having P1 and P2 products in it. I am doing it in SELECT Query, but don't know how to do it..? Need...
    • iXm
    • Thread
    • Replies: 35
    • Forum: Queries
  10. I

    Hello!

    Morning Everyone!
See more
Top Bottom