I HAVE A FIELD THAT IS HAS REPATITIONS SET TO INDEX 7 TIMES. I NEED TO TOTAL UP ALL THE NUMBERS FROM ALL SEVEN REPATITIONS IN A SEPARATE FIELD. DOES ANYONE KNOW HOW THIS CAN BE DONE?

Assuming you mean you have a repeating field and want the total for the first seven repetitions, create a calc field that adds them up -- using the "Get Repetition" function.

HTH,

Dan

P.S. In general, using all caps on the web is considered shouting; please refrain from doing so unless you mean to shout.

Sorry about the shouting. I could sure use more help. Lets say I have a repeating field named "Number" , That repeats 7 times. How would the calc read for the " "Total number" field. I noticed that the "GetRepetition" option contains (repeating

Ok Lets act like I'm really stupid! How would this calc look when define the "total" field.

I only have two fields.

" Number" this field has a repatition of 7.

and "Total Number" This will give a total of all the numbers in the 7 number fields.

Please don't get the wrong idea, I'm greatful for your help, but I'm also not advanced user.

Thanks,

RET

The calculation is just:

Sum(Number)

When you define the Total Number field, you select the "Calculation" option. Then you into the field options dialog. Enter the above formula as the calculation formula. Select "number" as the calculation result type from the popup menu at the bottom of the dialog box. That's it.

[This message has been edited by BobWeaver (edited March 20, 2001).]

Define a field:

TotalOfRepeats (calc, number) =

Sum(Repeating Field)

-bd

Thanks