Results 1 to 4 of 4
  1. #1
    Athanatsius is offline Novice
    Windows 10 Office 365
    Join Date
    May 2023
    Posts
    1

    Query to identify customers who ordered one product in a series but not the next ones.


    How can I create a query in Microsoft Access to list customers who ordered video 1 in a series but not video 2 or 3? The customer name appears (sometimes mutiple times) for each order in one column and the product ordered in another.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    For starters, how do you identify the 'first' in a series?
    Provide sample data as tables in post or attach database (follow instructions at bottom of my post).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What exactly are the tables and fields in your database?

    Product is a video with the name of series and the video volume number?

    What have you tried? What result?

  4. #4
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    If your product table has a BOM structure, you can create a query to see if someone has ordered the complete product or not. IMO without a BOM structure it is hard or impossible to do. You should have at least the following tables:
    - Products (BOM)
    - Customers
    - Orders
    - Orderlines.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-05-2022, 06:38 PM
  2. Multiple Customers to one product
    By Sc0tt1e in forum Forms
    Replies: 12
    Last Post: 12-02-2020, 06:56 AM
  3. Need query to identify new customers each month
    By StevelKnievel in forum Queries
    Replies: 4
    Last Post: 06-20-2018, 10:16 AM
  4. Replies: 6
    Last Post: 02-28-2015, 11:57 AM
  5. Replies: 1
    Last Post: 08-28-2013, 02:27 AM

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