Recent content by rhonda1111

Hello again, I actually couldn't use absolute value because it turned some of my negatives to a positive number that needed to stay negative... ugh So, now I wrote another cross tab query, and linked the two cross tabs together in another query so that I have both the positive numbers for the...

Hello, Thank you so much for your reply!! It does make sense to store the expenses as a negative and then do a sum. That helped tremendously. I am now able to calculate the net income by summing the amounts. Now, I am trying to show my numbers as positives rather than negatives in my...

Hi, Thank you so much for your reply. So, do I need separate tables for income and expenses in order to do this? It seems like I am missing something very basic, maybe the way I have my data structured. Thanks again!!

Hello, I am brand new to all of this, and hoping someone can help :D I'm trying to calculate net income - my data is stored on a table as follows: Account Amount Date I then have the data linked to an Account table which also identifies whether the Account is an Income or Expense Account. I...