Looping thru fields.

[Newby]

I am currently calculating a rolling 12 month average and I am set up a loop to collect the necessary data. For example for Aug 2012, I want the the sum of the first 8 months of 2012 and the last four months of 2011. So if January is the 5th field, I want ot loop thru the current record summing the next field 8 times (field 5-13). Then I want the last 4 months of last year's record. Field 9(13-4)-13.



I used MoveNext to go to the next record. Is there a similar reference to next or previoius fields?

Thank you in advance

John

[June7]

Yes. http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx

EDIT: Sorry, misread original post. See next post.

However, Fields Collection using index might only be relevant to recordset, not referencing form elements. Are you using RecordsetClone method?

[ssanfu]

So if January is the 5th field, I want ot loop thru the current record summing the next field 8 times (field 5-13). Then I want the last 4 months of last year's record. Field 9(13-4)-13.

You totally lost me... It sounds like you do not have a normalized structure.

In any case, look in Help for "Fields Collection". You can refer to a field by its ordinal number ie Fields(0),Fields(1), ...
Remember that the index is zero based, so the 5th field would be Fields(4). You can set up a FOR..NEXT loop to sum fields in a row.

[Newby]

You totally lost me... It sounds like you do not have a normalized structure.

In any case, look in Help for "Fields Collection". You can refer to a field by its ordinal number ie Fields(0),Fields(1), ...
Remember that the index is zero based, so the 5th field would be Fields(4). You can set up a FOR..NEXT loop to sum fields in a row.

Stupid question, how do i mark a thread as solved?

[ssanfu]

Look for "Thread Tools" at the top of the page. (right hand side of 2nd green green bar)