Results 1 to 3 of 3
  1. #1
    babar_bhaai is offline Novice
    Windows XP Access 2003
    Join Date
    May 2016
    Posts
    2

    Cant List all Items in query

    Click image for larger version. 
<br /><script async src=
    Name: output.JPG  Views: 10  Size: 155.3 KB  ID: 24762" class="thumbnail" style="float:CONFIG" />
    Click image for larger version. 

Name:	tables.JPG 
Views:	10 
Size:	106.1 KB 
ID:	24763

    Hi Everybody

    i'm new to the forum , need help
    i want all items of products with each record of customer even if they are not invoiced
    as shown in pics and sample is attached
    Attached Files Attached Files

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    If you want to show all possible combinations, you would use a Cross Join (also known as a Cartesian Product).
    Really, it is the absence of a join, so every record from one table/query is matched up with every record from another table/query.
    See: https://support.office.com/en-us/art...1-07061a1478f6

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I agree with JoeM, but leave the join between invoices and cust and remove the join between invoices and prod.

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

Similar Threads

  1. Replies: 2
    Last Post: 05-24-2016, 08:01 AM
  2. Replies: 5
    Last Post: 08-11-2014, 03:08 PM
  3. Replies: 3
    Last Post: 05-24-2014, 03:56 PM
  4. Replies: 1
    Last Post: 02-03-2011, 11:19 AM
  5. list box items
    By thewabit in forum Forms
    Replies: 12
    Last Post: 01-01-2010, 08:59 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