Results 1 to 2 of 2
  1. #1
    Kawa is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2015
    Posts
    1

    Searching database by number of linked records


    The title may not make much sense because I don't know how else to explain it with very few words. But basically, I have a database with three tables: Customers, Books and Orders (customers and books are linked to orders via their primary keys). And I need to have a query that shows all customers with 2 or more orders. Is this done by using some sort of sum?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    In a query, pull customers and count ([books])
    under the criteria for count, put: >1

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 03-02-2015, 07:54 PM
  2. DAO ADO and Query for searching records
    By TioAdjie in forum Forms
    Replies: 12
    Last Post: 02-20-2014, 08:16 PM
  3. Question on database structure - limiting linked records
    By andrewb in forum Database Design
    Replies: 2
    Last Post: 03-22-2012, 05:41 PM
  4. Replies: 10
    Last Post: 01-10-2011, 07:52 PM
  5. Searching records....
    By knightjp in forum Database Design
    Replies: 0
    Last Post: 01-07-2009, 05:20 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums