Newbies jblewis Posted April 12, 2001 Newbies Posted April 12, 2001 I'm constructing a database of daily reports. Each day's report is a new record. Field "A" in each day's report must show a running total of the numbers entered each day into field "B," but here's the catch--the running total shown in "A" needs to include all the previous days, but not the current day. Is there any way to exhibit a running total up to, but not including the current record? Thanks in advance for your help. Jim
StevenB Posted April 13, 2001 Posted April 13, 2001 Have you tried using Set Field [Field A,"Status(CurrentRecordCount)-1"]? This would set the field to one less than the total number of records. Hope this helps. Steven B
Recommended Posts
This topic is 8611 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now