By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,435 Members | 2,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,435 IT Pros & Developers. It's quick & easy.

Running total in calculation field in a report

P: 1
Hi, I have an interesting problem.
Without using reduncant data, how can I design a calculation field to get a running total from values in different records? I'm designing a usage/month report, and I'm confused.
Date Value Calculation
Record1: 08/05/06 12345
Record2: 09/05/06 23456 (23456-12345)
Record3: 10/05/06 34567 (34567-23456)

Thanks for the help.
Steve
Oct 6 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi Steve you can use

UNION QUERY

So do the query without calculation

Do a query with only one row the calculation but with the same columns

Than in SQL View Copy the Second One and paste it

in deleting the ; of the first and typing UNION

:)
Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.