Results 1 to 3 of 3
  1. #1
    RGatDP is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    May 2016
    Posts
    3

    Combine Duplicate Data?

    Hey all:

    I'm confused as to how to get started with this problem. I have a database that looks like such.

    Customer Product
    Allen Banana
    Beth Orange
    Curt Apple
    Allen Apple
    Allen Orange
    Curt Orange
    Diana Apple


    What I want it to look like is this:

    Customer Apple Banana Orange
    Allen Y Y Y
    Beth N N Y
    Curt Y N Y
    Diana Y N N

    Any suggestions?

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    According to the "rules" of normalization, your table should be left as it is. The way you want to to structure it, you would have to modify your table every time you added a new product, which would also mean having to modify all the queries, form and reports that use that "new" table - not a good plan (IMO)

    The table you currently have looks like it might be a join table in a many-to-many relationship. Can you tell us more about what it is you want to do?

  3. #3
    RGatDP is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    May 2016
    Posts
    3
    Sounds good. I guess what I would want to do is query such that I want to see which customers got just Apples, Bananas or Oranges, and then separate queries of those combinations (seven queries in total.) What would be my first step in that?

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

Similar Threads

  1. Looking to combine data
    By brentagade in forum Access
    Replies: 3
    Last Post: 03-24-2016, 11:35 AM
  2. combine data
    By jozino in forum Queries
    Replies: 2
    Last Post: 04-06-2015, 01:31 PM
  3. Replies: 7
    Last Post: 12-14-2014, 04:44 PM
  4. Replies: 3
    Last Post: 03-01-2013, 12:41 PM
  5. Combine data
    By DSM1957 in forum Queries
    Replies: 1
    Last Post: 07-16-2012, 04:51 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