Question regarding the SUM of numeric fields

Avatar

Avatar

RoC1909

Avatar

RoC1909

RoC1909

30-11-2010

Hey all,

Hopefully I have posted this in the appropriate forum (this could probably go into the JS forum as well and if so, my apologies.)

My question:

I have a monthly mileage log that has a field where the user will enter the the beginning vehicle odometer reading (this is a MANDATORY FIELD) at the beginning of the month OR when the vehicle is first used.

I then have 31 fields underneath corresponding to the days in a month with each field containing the ENDING odometer reading for that day. If the vehicle wasn't used on a particular day, that day's field would be blank. At the very bottom would be a "total miles" field. As a example, the data would be like this:

Beginning Mileage:     111,111

1st                            111,200

2nd                           111,300

3rd                           

4th                            112,000

5th                            112,300

6th

7th                            113,000

...

...

...

31st                          114,100

TOTAL MILEAGE        2,989

"Total mileage" = "Beginning Mileage" MINUS "the odometer reading of the 31st day AKA the LAST ENTRY FOR THAT MONTH"

Therein lies my issue. How can I make the "total mileage" field be dynamic? Let's say the vehicle was only used from the 5th through the 10th, how can I have the "total mileage" field display the correct odometer reading?

Hopefully, I explained this well enough for someone to help me and all help will be greatly appreciated.

View Entire Topic

Avatar

Avatar

RoC1909

Avatar

RoC1909

RoC1909

30-11-2010

Upon re-reading what I said in my last post, I didn't mean it in a BAD way that your ideas made me "revamp" my form. On the contrary, I made my form much more efficient.

I also wanted to say that I really enjoyed your tips on creating dynamic tables that I found on your website.Very informative and very cool what a person can do with Acrobat.

Thanks again,

Jon