Search results

Good morning, I am trying to add an amount criteria of >= $1000 to this report. What's wrong? Private Sub cmdFYTDBUEndowmentCommitments_Click() If Not IsDate(Forms![Development Report Manager]!ReportDate.Value) Then MsgBox "Please pick a Report Date!", vbOKOnly, Me.Caption: Exit Sub...

I posted similarly a while back and haven't been able to figure this out so I'm rewording in hopes to clarify. Functionality is perfect when I update the source data .MDB file that connects to my .accdb reporting. When any other user updates the .MDB, they can successfully view the new data...

Good morning, I'm looking for guidance on why user access would be different from mine. Other user is able to update the linked .MDB file and sees the updated data in the tables within .accdb file but then the built query shows up blank. Why would this be occurring? When I run them, everything...

=[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...

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...

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,

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...

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.

=Sum((Sum([SplitAmount]))+([Gifts with appeals not in an Annual Fund (FundType)].[Report]![FundAmt])) Im in the report using [SplitAmount]. I want to sum [SplitAmount] and [FundAmt]. Any ideas?

Hi there, I've created a report that runs from a form based on the selections within the form (different names). This report is essentially a 'hub' for 4 sub reports. The report runs fine Report View, but when I go to print preview or just try to export, I get an error and it eventually takes me...

I've inherited a report and am receiving #Error in this specific field that is using the following VBA code. 'Give me the account number when the following criteria is met.' Public Function PSAccount(sFundType As String, lFundCode As Long, sConstituency As String) As Long If Not...