I need some help.i have a report which has some fixed information. This information should be repeated several times based on the number in a field.
i have 2 tables. 1 has all the information to be reported. the other has 3 flds. 1 fld to link with the main table. the rest 2 flds are type and value. type says what the fld value can be. if its type 1 that means the value will be text, if its type 2 the value will ve date, if its type 3 the value will be a number. as shown below.
Type value
1 dfdfsd
2 12/12/2006
3 3

this report is a single page report. but i want the report to print as many times as shown in the value fld for type 3. so for this information i gave, the report should print 3 times. how to do this.

Thanks.