Personal Fund Manager

[RobertSanders]

Hi,

I'm trying to create a personal fund manager, but have the following problem.

The db contains 3 tables:

-Users
-Expenditures
-Income

'Users' contains the users
'Expenditures' contains expenditures per user, with a expenditure group (Look-up field)
'Income' is the same as expenditures but then with income per user

I can create queries that show the total income or expenditure per user, but if I want to calculate income - expenditures per user, the calculations go haywire!!!

While creating query that shows per User the sum of Income( or expenditure) it works.
But if I also want to show the sum of expenditures (or income) it all of a sudden adds up all the expenditures, not just per user.....

I know it sounds complicated, but could somebody help me??

Maybe I should combine the income/Expenditure tables?

 

[RobertSanders]

O yeah,

to make it more visual you can download the db here:

http://members.lycos.nl/robertsanders/Expenditures.mdb

(1.2 Mb)

the query where it goes wrong is called PROBLEMQUERY.
As you can see it tries to combine the queryresults from the 'Total'-queries. These queries do give the proper results.

But in the PROBLEMQUERY everything goes wrong.....

thanks for your interest


Robert Sanders