Results 1 to 3 of 3
  1. #1
    smithub is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2018
    Posts
    2

    Query not pulling all data

    Hi,
    I am querying two tables linked by Unique_ID. One table shows transaction volumes per row for each week. I want to see the last 13 weeks transaction volumes across in columns. So one machine per row with transaction volumes for the last 13 weeks. The weekending will appear as header in each column for these 13 weeks. For some reason, some lines are not pulling all the figures for the 13 weeks. Some machines show transaction volumes for say the 4th and 6th week but i know there should be transaction volumes for all.



    Appreciate any help on this.

  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
    If you have an inner join between the 2 tables and one has no data for some records, those records will be missing
    Try changing to an outer join
    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

  3. #3
    smithub is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2018
    Posts
    2
    Thanks ridders52 I'll give that a try

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

Similar Threads

  1. Data not pulling through to query
    By halnurse in forum Queries
    Replies: 1
    Last Post: 12-28-2017, 05:25 PM
  2. Pulling data into a form from query on a web app
    By DianeArthur in forum Access
    Replies: 0
    Last Post: 08-07-2016, 10:46 AM
  3. Query pulling the same data three times.
    By halabis in forum Queries
    Replies: 10
    Last Post: 10-29-2015, 09:56 AM
  4. Query pulling data from multiple tables
    By jetman5843 in forum Queries
    Replies: 3
    Last Post: 04-08-2014, 12:27 PM
  5. Have 3 tables - problem with pulling data for query
    By wulfhund in forum Database Design
    Replies: 2
    Last Post: 08-13-2010, 05:38 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