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

    View components as products

    I'm trying to design a query that could show (in a report or on a form) the number total of one of our products, for example sold in a particular month. The problem is that in some circumstances, we sell components separately, so that an order (and order detail) could include complete products or components only or both. The final tally should compute the components into products (in this scenario). I knew I needed a junction table and think I constructed it properly but I'm missing something about how to get to the final result. The date criteria isn't important here. I get zero results with this query. I had lookup fields in the junction table and realized that could be a problem so I changed that so it only enters the ID field and that didn't helpe.

    Any help would be appreciated

    Thanks


    Click image for larger version. 

Name:	Image 9.jpg 
Views:	7 
Size:	222.6 KB 
ID:	22286

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    seems very similar to http://www.utteraccess.com/forum/ind...wtopic=2032030

    When you cross post, please advise readers that you have done so. It isn't wrong to cross post,
    but it is considered proper etiquette/netiquette to advise readers.

    Good luck.

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

Similar Threads

  1. Replies: 5
    Last Post: 07-10-2014, 09:37 AM
  2. Replies: 3
    Last Post: 03-16-2014, 09:25 PM
  3. Replies: 8
    Last Post: 04-29-2013, 11:23 AM
  4. MS Graph problem with X and Y components
    By Triztan in forum Reports
    Replies: 1
    Last Post: 07-05-2012, 11:27 AM
  5. Replies: 8
    Last Post: 04-24-2012, 01:05 PM

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