Results 1 to 3 of 3
  1. #1
    Rhemo is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2012
    Posts
    10

    Select Query returning no Results

    I have a db with 2 tables, one containing basic info FirstName, Surname, YearGroup, and another table with other data. I imported a list of names into the first table, firstname and surname only were imported, other field was left empty, other table was also left empty. I made a simple select query to pull all records from both tables and i get no results at all. None of the imported names show on the query results. Would any one have an idea what Iam missing?



    Many Thanks

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    other table was also left empty
    That is they key phrase right there.

    My guess is that you did a simple Inner Join between the two tables. An Inner Join will only return matching records found in both tables. If one of your tables is empty, no data will ever be returned by such a query!

    If the Query Builder, if you double-click on the join line between the two tables, you will see two other join options. Select the appropriate one (the one that says "select all records..." from your table with data in it).
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  3. #3
    Rhemo is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2012
    Posts
    10
    Sorry for the long delay in replying. You were right, I tested with sample data in the second table and those entries started show after making a correction in the Query Builder.
    Many thanks!

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

Similar Threads

  1. Query returning more results than wanted
    By thedanch in forum Queries
    Replies: 4
    Last Post: 06-19-2012, 08:24 AM
  2. Multi Select Simple Returning No Results
    By jsimard in forum Programming
    Replies: 11
    Last Post: 01-24-2012, 10:28 PM
  3. Replies: 5
    Last Post: 10-27-2011, 09:08 PM
  4. Query Bug? Not returning consistent results
    By trb5016 in forum Queries
    Replies: 4
    Last Post: 06-15-2010, 12:00 PM
  5. Query not returning all of the results
    By velvettiger in forum Queries
    Replies: 4
    Last Post: 03-11-2010, 06:56 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