Calculating Net Income

%3CLINGO-SUB%20id%3D%22lingo-sub-2105884%22%20slang%3D%22en-US%22%3ECalculating%20Net%20Income%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2105884%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20am%20having%20trouble%20calculating%20a%20net%20income%20for%20my%20church%20management%20system%20in%20access.%3C%2FP%3E%3CP%3EI%20have%20two%20tables%2C%20one%20for%20Income%20and%20another%20for%20Expense.%20I%20could'nt%20join%20them%20in%20a%20single%20table%20because%20there%20are%20lots%20of%20information%20in%20each%20table.%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20Total%20USD%20and%20LD%20from%20Income%20table%20-%20Total%20USD%20and%20LD%20from%20Income%20%3D%20Balance%2FNet%20Income%3C%2FP%3E%3CP%3E-%20Creating%20it%20on%20a%20form%20will%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2105884%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENet_income%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, am having trouble calculating a net income for my church management system in access.

I have two tables, one for Income and another for Expense. I could'nt join them in a single table because there are lots of information in each table. 

Example: Total USD and LD from Income table - Total USD and LD from Income = Balance/Net Income

- Creating it on a form will 

0 Replies