Search results

I'm not sure this is true since I'm able to call the FundAmt with a textbox in the other report using =[Gifts with appeals not in an Annual Fund (FundType)].[Report]![FundAmt]

=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?

No sure I'm fully understanding, but I attempted this with no luck. Why would the full report open in report view but not in print preview when it's using the same filter?

Solicitors is based on a table.

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

Here's my design. In Report View, it appears as needed (credit line and debit line with headers). When I export, it puts the credit info next to the debit instead of under in a row as displayed.

Am I missing some kind of communication to let it know that data row 2 should be in the same column as data row 1?

I've figured out that row 1 is put in to the spreadsheet and then instead of row 2 being places under it, it's next to row 1 data. Essentially creating more columns

I have to create a pseudo line of data. My data only shows debit account info. So I've got two lines in detail. One with actual imported data and one that is just text fields with the credit account info.

Ok folks, I was able to get all needed data into my query. Yay! Now, I've created my report (that is to be exported to excel and sent to accounting). In Report View, everything looks great. But when I export it, fields are missing are fields are in the wrong places. Any ideas?

Another option I saw was a Switch function, but I was unable to figure out how to apply that to the logic needed here.

It wouldn't allow an excel.

See attached for the logic.

Ok, I went ahead and just stuck the criteria in to my SQL as I was having issues with linking the table to my imported DB tables. It's working. However, I've run in to an error when having two sets of criteria left. I suspect I've done too many nested statements. Any suggestions for a work...

Makes sense. I'll give this a shot. Many thanks!

Thanks for the response! There is still a learning curve with this report. What would that look like in terms of each criteria met? If fundcode = 610 and constituency = alumni then 1? and repeat for each?

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