Search results

Had the original backwards. I've attempted this: =[Commitments]/((iif([FY S&S].[Report]![S&S#Commitments] isnull,[TotalCommitments],[FY S&S].[Report]![S&S#Commitments]))+[TotalCommitments]) When [FY S&S].[Report]![S&S#Commitments] is zero, I get the #Type! error. When it is not zero, this...

Thanks, I'm still receiving the #Type! error with this.

S&S#Commitments + TotalCommitmentswould not total zero

=[Commitments]/((iif([FY S&S].[Report]![S&S#Commitments] isnull,0,[FY S&S].[Report]![S&S#Commitments]))+[TotalCommitments])

Hi, I had to build this obnoxious report for accounting purposes. One gift can have many (10+) accounts (funds) associated with it. And the debit account can be one of many. Here's a snippet of what I came up with. It functions well, other than the fund count being higher than 8. Any...

I've embedded a sub report and am able to use the total count from that, add the total count of the original report and have the sum calculate the percentage properly. I'm also able to show the calculation for the sub report but only in the main report. Here is the successful source...

That was it. Thanks!

Any Ideas?

Another inherited report that is not counting correctly. Here is what was written: Me!FYTDNewDonor.Value = ECount("[Constit_id]", "[FY Gifts]", "[DTE] BETWEEN #" & dFYStart & "# AND #" & dReport & "# AND ([FirstGiftDate] >= #" & dFYStart & "# or [FirstGiftDate] is Null)") I need the distinct...

Exactly what I needed. Thanks!

I have created a report based on two groupings: Campaign and FY. I need to change this report to show campaigns on the y-axis and then give me the detail of each FY horizontally. Any guidance on how to do this? Thanks in advance,

Not sure I understand. I'm wanting a query that sums if the appealID is the same. But we have new appealIDs frequently, so it needs to be a generic formula somehow.

EAppealID ExpenseAmt G1 $1,000.00 G1 $600.00 G1 $40.00 G1 $42.00 G1 $1,200.00 G1 $1,400.00 F2 $30.00 F2 $300.00 F2 $30.00 F2 $150.00 F2 $75.00 F2 $400.00 EAppealID ExpenseAmt G1 $4,282.00 F2 $985.00

I only want to sum if the AppealID is the same. Not sum all.

Columns: AppealID, ExpenseCode, ExpenseAmt There can be several Expense codes per AppealID but the AppealID table will change over time. How can I generically say SUMIF ("AppealID is the same",ExpenseAmt) What I don't want to do is have to recode this each year when new AppealIIDs are added...

Union Query: (SELECT [AppealsGifts With Appeals].Gf_Apls_1_01_Amount AS AppealAmt, [AppealsGifts With Appeals].Gf_Apls_1_01_Appeal_ID AS [AppealID], [AppealsGifts With Appeals].Gf_Apls_1_01_Description AS AppealDesc, [AppealsGifts With Appeals].Gf_Apls_1_01_Ap_No_solicited AS NoSol...

Thanks to you both. Maybe DCount is not what I am wanting or perhaps there's an extra piece needed. I have the report grouped by a criteria (AppealCode) and for some reason when I add this field, it is just giving me total count for all rows in [Appeal Gifts]. Other calculations are working as...

I have a query[Appeal Gifts] with a column named [Constit] Not sure what I'm doing wrong here: =DCount([Appeal Gifts].[Subtype], [Appeal Gifts], [Appeal Gifts], ([Subtype] is not null)) I get the error: The expression you entered has a function containing the wrong number of arguments.

I hadn't named the other total. Once I did, this worked! I appreciate your help.

Two different totals that reside in two different reports