Annual Report Query with Selected Soft Credits

Trying to create a query for our annual report that shows donors who have contributed over $1000 in the span of a year.  I also want to bring in individuals who are soft credited and who have donated over $1000.  I'm doing this because my predecessor spent a year hard crediting payment platforms (Square, Strip) and donor platforms (Fundly, I Live Here I Give Here).  So I have a ton of records where the hard credited donor is not a person or an organization, but a platform or a payment structure, and the person and the organization is soft credited.


I'm having a very difficult time creating a query that pulls this data.  


I have a query that gives me hard credit for over $1000, and one that shows soft credit over a $1000.  I thought I could merge the two and get a nice report that lists who gave what, but even though I use GL Post Date between as a criteria in both queries . . . the merge shows everything!  I'm looking for gifts in 2017, and I'm getting all the way back to 1995.



These are the criteria for the queries:


Hard Credit:

Total Amount of Gifts greater than or equal to $1000

     Gift GL Post Date between 1/1/2017 AND 12/31/2017

     AND Gift Type one of Cash, Pay-Cash Stock (Sold), Pay-Stock/Property (Sold), Pay-Other, Recurring Gift Pay-Cash

AND Gift GL Post Date Between 1/1/2017 and 12/31/2017

AND Gift Type one of Cash, Pay-Cash Stock (Sold), Pay-Stock/Property (Sold), Pay-Other, Recurring Gift Pay-Cash

AND Anonymous? Equals No.


Soft Credit:

Soft Credit Recipient Last Name not Blank

AND Soft Credit Amount greater than or equal to $1000

AND Gift GL Post Date Between 1/1/2017 AND 12/31/2017

AND Gift Type one of Cash, Pay-Cash Stock (Sold), Pay-Stock/Property (Sold), Pay-Other, Recurring Gift Pay-Cash



Is there a more eloquent way to get my desired outcome?  

OR is there a report that can help me out and create a much nicer outcome and running total . . . but not one where every individual is on one single page a piece.