Subtracting within the same field

  • Thread starter dp724 via AccessMonster.com
  • 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top