Results 1 to 2 of 2
  1. #1
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133

    Post Relate a two Queries

    Hello Everyone

    Is this method correct for relate a two queries?



    I have a Table for Order , and also I have a Table for Purchase , Even I be able to control my Goods
    I want to know how many kind of Goods have I in any Products factory ,,, Maybe I will have relate with more than 10 factories to buy Goods from them .
    so that , I want to know How many kinds of any kinds of Goods I have in every factories .
    for example : I have these kinds of Goods _

    20*40 = 10 tons , Price : 200$ , Factory Name = A
    20*20 = 15 tons , Price : 200$ , Factory Name = A
    30*30 = 20 tons , Price : 220$ , Factory Name = B
    40*40 = 20 tons , Price : 220$ , factory Name = B

    I created a related between both , even it shows me detection of materials , which kinds of Goods have I in any factories ( kinds of Goods , Price and Factory )even it tells me , you have : 20*40 = 10 tons , price : 200$ , Factory Name = A .... and so on .
    Click image for larger version. 

Name:	Capture.JPG 
Views:	27 
Size:	19.8 KB 
ID:	32174

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Hi Mehvan

    I see nobody has answered this.
    I didn't really understand what you were asking so left it for others - it may be that was the case for other forum members as well.

    If you haven't solved this problem, I suggest you ask again in a different way
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 2
    Last Post: 08-06-2015, 12:47 AM
  2. Best way to relate these tables.
    By rosco2382 in forum Database Design
    Replies: 2
    Last Post: 03-10-2014, 03:56 PM
  3. Relate two calculated fields
    By fedebrin in forum Access
    Replies: 22
    Last Post: 06-21-2013, 01:59 PM
  4. I just DON'T know how to relate Tables - PERIOD!
    By djclntn in forum Database Design
    Replies: 6
    Last Post: 02-26-2012, 07:21 PM
  5. doesn't relate
    By mhh12 in forum Programming
    Replies: 1
    Last Post: 08-01-2010, 11:55 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