I'm a complete newb blundering my way through CR.  I'm trying to create a giving history report which lists a total amount given by fund per year for a one year period. Unfortunately for 2 of my columns it lists the same gifts twice, but only for those folks who have made more than one gift.

I have Select Distinct Records Selected.

I did a bit more experimenting and I get the correct gifts listed and total until I add a specific data category. As soon as I place the data for that category, my gifts get doubled (if only it were true!)

Is there a reason that data could interact in this way?

You are a genius! You'll see why at the end of this...

My linking table holds just that, all the links to each data piece. So Link has 10 links going out of it (all left outer join, not enforced, = ).  9 of these tables contain one gift category's (Fund's). Each of the 9 Fund tables contains 3 pieces of data, Gift ID, Gift Amount, and Gift_Link. Each Fund can have multiple gifts, one gift, or no gifts.  The 10th table contains identification information; Name, ID, First Name, Last Name, and Name_Link. The 10th table has one value for each record.

I believe I used auto link and then changed everything to Left outer joins .
My groups are done and sorted by Last Name.


And I just had a breakthrough! I went back to an old attempt where it appears to be correctly listing gifts once. On this report I have inner joins and "return all rows before joining" so I'm guessing that I used an incorrect linkage (they need a whole "how to" on links, I swear).

So if I'm correct, a new question. On my new report (which is all done except that annoying incorrect linkage and doubled numbers) I can't get the box to appear that lets me select "return all rows before Joining" to appear, its only available on my old report.  How can I get that option to appear and be selectable?