Financial Reports By Date, Member, Family, Fund, or Amount

erkerns

Registered User.
Local time
Today, 04:54
Joined
Jun 13, 2003
Messages
10
I am new to access and programming in general. This is my first real project and I am just about finished. Just trying to tie everything together, clean up the db and add the final graphical design and layouts. My last major task has me stumpped. I am trying to generate reports of donations based on user input on the opening of the report. For example report all donations for member John Doe, Or report only donations of John Doe to the missionary fund in the month of January 2003, Or Report all doantions of all members to the general fund for the months january 2001 and january 2003 etc. I have two tables related by memberID tblmembers, and tbldonations. I am doing this database free of charge and would appricaite any help I can get. Maybe there is a ready made report for something like this, or if someone can throw something together that I can modify I would appreciate it. Please be specific and give step by step instructions if possible, as I am still learning.
Thanks in advance!

Earnest

See attached file (I have removed most table to reduce file size)
 

Attachments

Use multiple combo boxes to select the criteria you need, then build a string SQL recordsource to report same.

Combo boxes could be
Member Name
Contribution Type

Interval could be either text boxes or combo boxes.

your report Recordsource would be

"Select * from TABLENAME where MemberID = " & me!cboMemberID & " AND ContributionID = & me!cboContributionTypeID & Date between #" & me!txtStartDate & "# AND #" & me!txtEndDate & "#;"

or something like that.
 
Thank you, I will give it a try. I am more of a WYSIWYG user but the code is simple enough I think I can manage it.
 

Users who are viewing this thread

Back
Top Bottom