Recent content by askajan

The file is attached so you can see the problem I am running into.

Can I not use some formula that says: Calculation1 = Column A When Revenue - Column B When Expense

Alan, Okay, so I have my query setup as such: Category Amount Revenue $100 Revenue $500 Revenue $400 Expense $200 Expense $200 When I create an expression within the field of a query, it appears that since the revenue and expenses are in the same column, I can't...

Gotcha thanks.

How would I implement that code into a report?

Is it possible to create a calculation between groups? For example.... Group Revenue Group Operating Expenses Calculation1 = Revenue - Operating Expenses Group Other Expenses Calculation2 = Calculation1 - Other Expenses ?

I have this: Revenue Item 1 $100 Item 2 $100 Item 3 $100 $300 Expenses Item 1 -$100 Item 2 -$100 $-200 Net Income $100 I need this: Revenue Item 1 $100 Item 2 $100 Item 3 $100 Total Revenue $300 Expenses Item 1 -$100 Item 2 -$100 Total Expenses -$200 Net Income $100...

Ok. I will work on this tonight.

So make very expense a separate record i.e. ID, ClientName, Year, RevenueOrExpense ?

SO... Year ClientName RevenueDescriptionNumber Revenue$ RevenueBenchmarkCat 2012 Acme 3 $30k 5 ?? The only problem is that I won't know the description for the RevenueDescriptionNumber field until each client sends me their financial statements...

Ultimately, I am trying to enter an income statement (revenue items and expense items) for each year, for each client. Then classify each expense according to the category used in industry publications (for example, what a client calls supplies, I would like to classify as either administrative...

I have a field named Supplies Expense. As an analyst inputs a business's expenses, it may require multiple entries into this one field. What is the best way to accomplish this? For example: Supplies Expense (Field Name) [$0.00] The analyst has the following data: 2009 Financial Statement...

Anyone out there?

My navigation form has 3 tabs on top, and subtabs for each of these on the left side of the screen. Is it possible to change all of the contents of these forms based upon a drop down list on top of the navigation form? For example, I want to select a client name on top of my screen and then...

I have run into a wall building my database and am seeking the help of the experts in this forum. I want the user to be able to enter the following based on the client's financial statements: RevenueItem1 RevenueItem2 RevenueItem3 RevenueItem4 RevenueItem5 NetRevenue ExpenseItem1 ExpenseItem2...