Subtracting within the same field

  • Thread starter Thread starter dp724 via AccessMonster.com
  • Start date Start date
D

dp724 via AccessMonster.com

Hi Guys,

My report includes a column of values which come directly from one field.
The list is a running sum total of monthly expenses. Right next to this
column I’d like to have a column which represents the difference of each
month; representing the actual monthly expense.

For example, my monthly running sum column is 25, 75, 90, 110, 145 and my
column next to it would be 25, 50, 15, 20, 35, the actual monthly expense.

Since only the running sum total value is entered recorded in one field, how
can I arrange the second column to show up on my report besides my first
column? I thought it would be an easy query, but I’m having no luck.

Would greatly appreciate any help.

Dave
 
Back
Top