Forum Discussion

nicoleethier's avatar
nicoleethier
Copper Contributor
Oct 31, 2024

Access - how to joining two queries with different data without doubling data

I'm not sure how to phrase my issue, which makes finding a solution also difficult   I'm trying to combine two different queries so I can run a report that shows all of the crops FarmerID is growin...
access
office 365
nicoleethier's avatar
nicoleethier
Copper Contributor
Oct 31, 2024
I couldn't figure out how to find my question on the other forum. I thought I'd get e-mails if anyone replied, but I didn't get any. I had no intentions of being rude or being a pain. Thank you for the link, but please don't be too quick to make assumptions.
XPS35's avatar
XPS35
Iron Contributor
Oct 31, 2024

nicoleethier There are problems sending notifications on that forum:
Please note, the notification system in the Community is partially broken
You might not receive an email informing you that there is a new reply in a thread you are following. We are working on fixing this as fast as possible. Please make sure to periodically check the conversation to see if there are any updates. 

  • nicoleethier's avatar
    nicoleethier
    Copper Contributor
    Oct 31, 2024
    I tried to find my original conversation to check for updates and I couldn't remember how I found it. Trust me, I find it frustrating when people ask for questions because they can't bother to look themselves. I try very hard NOT to do that. I am new to this forum and again had no intentions of being rude.
    • Ken_Sheridan's avatar
      Ken_Sheridan
      Brass Contributor
      Nov 02, 2024

      You’ll find your original thread at:

       

      https://answers.microsoft.com/en-us/msoffice/forum/all/combining-queries-with-different-data/f287174d-a357-471d-9e4a-3f6e9bd64ad5

       

      As you’ll see the consensus there was that you either need a UNION query, or you continue to use two subreports.  In the latter case you might have to amend the sorting and grouping in the report to achieve the result you want.

       

      As regards a UNION solution the key thing here is that  we see the SQL statements of your two existing queries on which the subreports are based.

       

      I think what would help us most in advising you appropriately, however, would be if you could post a copy of your file, stripped of any personal or otherwise sensitive data, to a globally shared folder on OneDrive or similar.  We’d then be able to download the file and be in a far better position to advise you constructively.

    • XPS35's avatar
      XPS35
      Iron Contributor
      Oct 31, 2024

      nicoleethier 

      Just a few points regarding your question.

      1. It seems you have the same data in two places. That is normally not a good idea. Can you explain more about the background?
      2. In order to compare 2 lines, they must have a common unique identifier. That is not the case here. FarmerID is not unique anyway.
      3. What if there is data in both queries, but different? Like 6 acres vs 7 acres.

       

      Posted in both forums, just make sure 😁

Resources