Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Query showing more than it should

    I was hoping to display the number of bookings within the area only instead of giving me a total of 18 bookings - I'm getting additionals - and it only happens when I add the table areas.



    Click image for larger version. 

Name:	Capture.jpg 
Views:	7 
Size:	31.7 KB 
ID:	13667
    This is the result

    Click image for larger version. 

Name:	Capture2.JPG 
Views:	7 
Size:	158.3 KB 
ID:	13668
    This is table relationship in the query - I don't know why adding areas doesn't just show me the bookings for that area.

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    I've pinned it to it only ads the extra results when I add the junction, it's adding the bookings I have excluded in the query.

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

Similar Threads

  1. Replies: 3
    Last Post: 10-17-2012, 09:24 AM
  2. Query not showing all entries
    By HeadGasket in forum Queries
    Replies: 5
    Last Post: 02-09-2012, 05:21 PM
  3. Query Showing No Activity
    By tabbycat1234 in forum Queries
    Replies: 9
    Last Post: 12-06-2011, 06:09 AM
  4. Query not showing all records
    By gazzieh in forum Queries
    Replies: 2
    Last Post: 02-17-2011, 08:11 AM
  5. Query Showing Non-Assigned
    By Flash76 in forum Queries
    Replies: 13
    Last Post: 02-03-2011, 01:40 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