P
Pete
Hi
Can anybody suggest the best way to loop through a set of questions which
are structured to 4 levels, each on a different column and row.
Number of main section: column A
Number of sub section: column B
Number of sub sub section: column C
Number of sub sub sub section: Column D
Actual question: column E
The set of questions may vary and I need to be able to evaluate the answers
(according to a matrix to the right of the question) in an orderly way,
summarizing by section.
I will also be writing some routines to edit, insert and/or delete questions
(via forms) so the program needs to pick up the level number as it works its
way down/along.
Do I use a For/Next loop or Do/While loop and if so how?
Is there another type of loop better suited to the problem?
Sample of structure:
1 FINANCIAL RESOURCES
1 Long Term loans
1 Cash
1 Is there a written agreement?
2 Are all long term loans . . .?
3 How much needs . . . ?
4 Is the annual interest . . . ?
2 Other
1 What . . ?
2 Do ... ?
2 Short Term Loans
1 General
1 What are . . .?
2 When do . . .?
3 Give the . . ?
2 Inter-company Transactions
1 Are all inter-company loans . . .?
2 Are all inter-company interests . . . ?
2 MONETARY DEALINGS
1 Etc
1 Etc
1 Are etc
Thanks,
Peter Bircher, SA
Can anybody suggest the best way to loop through a set of questions which
are structured to 4 levels, each on a different column and row.
Number of main section: column A
Number of sub section: column B
Number of sub sub section: column C
Number of sub sub sub section: Column D
Actual question: column E
The set of questions may vary and I need to be able to evaluate the answers
(according to a matrix to the right of the question) in an orderly way,
summarizing by section.
I will also be writing some routines to edit, insert and/or delete questions
(via forms) so the program needs to pick up the level number as it works its
way down/along.
Do I use a For/Next loop or Do/While loop and if so how?
Is there another type of loop better suited to the problem?
Sample of structure:
1 FINANCIAL RESOURCES
1 Long Term loans
1 Cash
1 Is there a written agreement?
2 Are all long term loans . . .?
3 How much needs . . . ?
4 Is the annual interest . . . ?
2 Other
1 What . . ?
2 Do ... ?
2 Short Term Loans
1 General
1 What are . . .?
2 When do . . .?
3 Give the . . ?
2 Inter-company Transactions
1 Are all inter-company loans . . .?
2 Are all inter-company interests . . . ?
2 MONETARY DEALINGS
1 Etc
1 Etc
1 Are etc
Thanks,
Peter Bircher, SA