millrene

Thank you Ender. You gave me the courage to delete some of the files that aren't part of my problem and get it slimmed down. I have the file attached. It isn't going to look pretty once you open it because I had to delete so much. It is also password protected (sorry). You must use ADMIN and FMSA (in caps). Once you get it open go to Scripts and run the only script that is listed. It will take you to a layout where you will select the month and year. Please select January 2007 because I know the data for that time period. The first page of the report won't show you the problem. Go the next page. You will see Beg Bal_R and Beg Bal_D and Total Beg Bal, which is suppose to be Beg Bal_R minus Beg Bal_D. In some cases it works correctly, but in some cases it doesn't. I explained what it does in my first post if you want to check that. If anybody can solve this mystery it would be so wonderful. I have been pondering it for the last two weeks. Ugh! FileMaker_Donations.zip

I have finally gotten my file off of the server and ready to post. Now I find it exceed the limit to post to this forum. It is an application that we bought from FileMaker and I have customized it to meet out needs. Since it was a pre-built application it has two files and tons of tables, the smallest I can get it is 1.55 MB. I guess there is no hope unless anybody has an idea...

This is embarrassing, but somehow the password that we had recorded as the Admin Server Password is not working. We are not able to log onto the Admin Server anymore. Is there anyway around this problem? Believe it or not we keep our passwords in a filemake database, but it appears somebody didn't update the database.

I was afraid you would ask for that. Unfortunately the database is not a local copy. It has been uploaded to FileMaker server. Our Server Admin guy can't remember the password to the FileMaker Admin so we can't get a local copy right now. (He is busy). Maybe tomorrow. Thanks for offering to look.

I have been struggling for over a week to solve this problem and I am hoping somebody can see my problem. I am trying to get a beginning balance calculation to work. I have a doantions table, disbursement table and a cause table. The cause table keeps tracks of what a donation was given towards. I need to get a calculations that will show me the beginning balance for each Cause. This would be Donations minus Distributions for each Cause Code (ProjectID). I have created a calculation that shows me the beginning balance for donations in one field BegBal_R. This is based on what reporting month the user selects. So if they want the beginning balance for January 2007 it would show all donations prior to January 2007. I have set up the same thing for Distributions and the field name is BegBal_D These calculations are working fine. My problem arises when I try to do a calculation that is BegBal_R - BegBal_D. This calculation works if there has only been one donations and one distribution. Or if there has only been 1 donations and no distributions. If there has been multiple donations it will take the first distribution for that cause and muliply it by the number of donations. For example one cause had four donations for a total of 285.16. It had one disbursement of $103.81. It calculates the beginning balnce of a negative 130.08, which is 285.16-(4*(103.81)) I don't have any fields defined as repeating. I have the donations table and distributions table related based on a Project ID. Every time a donation is made it is assigned a Cause and the cause has a Project ID. Every time a distribution is made it is assigned a Project ID. I hope somebody can see the error. I appreciate your time looking into this problem. Thanks so much. Rene

I got it figured out! I created a field RptMtYr that concatenates ReportYear and ReportMonth. Then I created a field DonationMtYR that concatenates Year and Month of Donation_Date. Then I edited my calculation to:If(DonationMtYr ≠ RptMtYr;Amount;" ") Now it display all previous donations except the report month specified.

Hello, I have a database that tracks donations by donor and by the cause they donated to. I need to create a report that will show a specified month's total donations in one column and the summary of all prior donations in another column. Eventually I will have total balance column which would add those two fields together. I have created two global fields; ReportMonth and ReportYear that allows the user to select the month and year to print. I have created a calc field called RptMtDonations. It has this calculation:If(Year(Donation_Date) = ReportYear and MonthName(Donation_Date) = ReportMonth;Amount;" ")This returns the donations for specified month and year. I am struggling with how to calculate the prior months and years donations. I have tried this calculation:If(MonthName(Donation_Date) ≠ ReportMonth;Amount;" "). This works except it skips the month specified in prior years. I can't figure out how to work around that. Any suggestions would be greatly appreciated!

I have created a subsumary report. I have field called Disbursements that shows the amt disbursed for different projects. The summary field is DisbursementSum which sums the total of Disbursements. Disbursements is a numeric field that is indexed. The sub summary part it is sorted by location. The summary field of DisbursementSum is not showing any data. I am viewing it in preview mode. Any ideas what I did wrong? Thanks in advance for any assitance.

I have two tables: Cause and Disbursements. In Disbursments I have a primary ID. In Cause table I have a Foreign key field that I want to reference the primary ID in Disbursements. I was hoping to create a relationship between these two tables based on Primary ID(disbursements) and Foreign ID(Cause). The foreign key does not seem to be populating with primary key data. What is the best way to get that to happen or to create a relationship between these two tables.

Fitch, Thank you so much! That was the answer I was searching for! I had tried something along those lines, but I kept spinning in circles and wasn't getting anywhere, but frustrated. I love FileMaker. It is a cool program and I am looking forward to learning more. RM

Hello, I am new to FileMaker and I am trying to create summary report. I have a donations database. I have a Donation table that tracks Amount, Date, donationID, etc. I have Cause table that has LocationID, Project_CodeId and CauseId that the donation was given towards. I have created a relationship between these two tables based on Primary Cause Id and Foreign Cause ID in the Donation table. I have a summary field called Amt_Sum that summaries the Total of the Amt field. In my report, which is based on the Cause Table, I have it sorted by Location Number and then Project Code. I have the Amt_Sum field (which comes from the relationship between Cause and Donations table) in the body and it displays the toatal amt of donations given for a particualr Project Code. I have a sub-summary (trailing) part that I want to a total of all donations for that location number. I have the Amt_Sum field again, but it only shows the value of the last project code of that location. I have spent way too many days trying to figure out what I have done wrong. I hope somebody with more experience can see my error. I hope I have given enough detail to understand what I am trying to do. Thanks in advance for any help. RM