Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012
    Posts
    3

    Unanswered: Probably a dumb question: regarding queries and including all records

    Hello, this is my first post here... I apologize in advance for questions that seem dumb/obvious.

    Ok. So I built an Access database for storing patient data. And I'm building a query which will reference another query for one of the fields (I want it to return a specific score from a test which the patient will have taken many times, so the first query narrows down the result to the score I want using several influencing factors, and then the second query pulls that score along with other info about the patient's records overall).

    Basically what I want to know is this: how do I get my second query to not eliminate all the patients who weren't pulled in the first query? Like right now if I leave out the score from the first query, the second one pulls data for all the patients as it should, but as soon as I add in that other field, is removes any patient that wasn't in the first query.

    How do I bypass this/make Access return all the records, regardless of whether or not they appeared in the first query?

    Once again sorry if this question is dumb, usually I find answers by searching other ppl's posts in database forums but I didn't really know how to search this question in just a few words (hence the long post).

    Thanks all
    Last edited by neuro_data_girl; 12-07-12 at 13:35.

  2. #2
    Join Date
    Dec 2012
    Posts
    3
    Problem solved. Needed to change error in table relationships.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •