Query - Two or more modules

Postby WPC Munster » Thu Mar 15, 2018 1:42 pm

Can one write a query that obtains data from two or more modules? For instance, write a query that accesses data from the Membership module and the Contribution module.
WPC Munster
 
Posts: 7
Joined: Wed Mar 06, 2013 12:28 pm

Re: Query - Two or more modules

Postby NeilZ » Thu Mar 15, 2018 3:16 pm

WPC Munster wrote:Can one write a query that obtains data from two or more modules? For instance, write a query that accesses data from the Membership module and the Contribution module.


Yes, to a point. What are you trying to put together?

Neil Zampella

Using PC+ since 1999.
NeilZ
 
Posts: 8904
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

Re: Query - Two or more modules

Postby WPC Munster » Mon Mar 19, 2018 7:57 am

NeilZ wrote:
WPC Munster wrote:Can one write a query that obtains data from two or more modules? For instance, write a query that accesses data from the Membership module and the Contribution module.


Yes, to a point. What are you trying to put together?


I'm putting together a report that will contain certain Family data, Profile data, Attendance data, and Contribution data. I can get the Family, Profile, & Attendance data in one query in the Membership module. And I can get the data I want in the Contribution module with a separate query. However, then I have to sit down and using the two reports come up, manually, with the special report I need. I have over 600 line items to review. Tedious to say the least. None of the P/C canned reports fits my need for this specific project.
WPC Munster
 
Posts: 7
Joined: Wed Mar 06, 2013 12:28 pm

Re: Query - Two or more modules

Postby NeilZ » Mon Mar 19, 2018 8:39 am

WPC Munster wrote:
NeilZ wrote:
WPC Munster wrote:Can one write a query that obtains data from two or more modules? For instance, write a query that accesses data from the Membership module and the Contribution module.


Yes, to a point. What are you trying to put together?


I'm putting together a report that will contain certain Family data, Profile data, Attendance data, and Contribution data. I can get the Family, Profile, & Attendance data in one query in the Membership module. And I can get the data I want in the Contribution module with a separate query. However, then I have to sit down and using the two reports come up, manually, with the special report I need. I have over 600 line items to review. Tedious to say the least. None of the P/C canned reports fits my need for this specific project.


If you're looking for a report to tell you who has attended and given, there are two available under the Personal Profile reports. The Active Profile report lists everyone who has given and/or attended during a specified period, and the Non-Active Profile report which will list who as NOT attended and/or given during a specified period.

If there's anything else you want you would have to export the database to Access tables, and use access to create the report as you can't access the attendance and the contribution databases using a custom report.

Neil Zampella

Using PC+ since 1999.
NeilZ
 
Posts: 8904
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

Re: Query - Two or more modules

Postby WPC Munster » Mon Mar 19, 2018 10:46 am

Thanks for response. Canned reports don't quite cover what I'm looking for. Will look at your suggestion using Export / Access method. Again Thanks.
WPC Munster
 
Posts: 7
Joined: Wed Mar 06, 2013 12:28 pm