Combining NonRelating Totals into one Report

[Kjonnnn]

I have two databases.

MemberDatabase, is for entering member contributions. Only money received from members go in this database. So every contribution is attached to a member. It consists of two tables.

tblMembers, just has the member first and last name fields.

FIELDS:
MemberID/FirstName/LastName

tblOffering, just has fields for what the members contribute (Tithe, Offering, Missions, etc).

FIELDS:
OfferingID/MemberID/Date/Tithe/Offering/Missions

The two table are related by the tblMembers ID, which also looks up the names from tblMembers
Everthing works find in this database. I have various reports set up to give weekly totals and a year letter with totals.



The second database is the FinanceDatabase for general finance. The purpose of this table was to give a complete view of income and expenses. It's just one table.

FIELDS:
FinanceID/Date/Type/Item/IncAmt/ExpAmt

Type goes to a lookup table to determine if the Item is income or expense.

This table works fine for me. Right now, someone has to type in the totals from the MemberDatabase into the Finance Database.

NOW ... my question is, is there a way to combine the totals I from the MemberDatabase into the FinanceDatabase so they dont need to be retyped? Is there some way to relate the tables so that in the FinanceDatabase I can create a query that would get totals from the MemberDatabase and make a report that would show and calculate the totals from the other database and calculate them with the entries in the FinanceDatabase.

I hope I clear.

 

[KenReay]

Hi

There does not appear to be a common column on which to make a relationship,

but waht you could do it to make two reports, one for each table, then combine these two reports as sub reports onto a single report

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Kjonnnn]

Ok Thanks. I'll try that.

 

[bhoran]

I would think you could roll up the amounts on the members table by date or just the amounts then do expressions stating what the extra info is ie. FinanceID/Type/Item/IncAmt/ExpAmt and update the table. No problem there but to then relate it back by member would not be possible but maybe by date in an aggregated format or you could have 2 separate reports (one as a subreport running off the queries and comparing the totals of each table if that is what you are after.

I hope I got the right idea here.

Cheers