Repeat detail section of report

[Guest]

Hello!
I would like to produce a report with multiple copies of the same adress,
that is with the detail field repeating with the same value. Should this be
done in the query that provides data for the report or in the report itself?

I would be so pleased if anyone could help me on this.

/Krille

 

[Rick Brandt]

Hello!
I would like to produce a report with multiple copies of the same
adress, that is with the detail field repeating with the same value.
Should this be done in the query that provides data for the report or
in the report itself?

I would be so pleased if anyone could help me on this.

/Krille

One method is to create a table with a single integer field and fill it with
consecutive numbers (1, 2, 3, etc.).

Then include that table in your query with no join line. This would
ordinarily produce a cartesian result where every row in your normal query
will be repeated for every row in the number table. So if you entered 10
numbers in the number table all your query rows would be repeated 10 times.

If the number of repeats you want is static just enter the desired number of
rows in the number table and your done. If you need it to be dynamic enter
numbers up the highest value you think you will ever want and then you can
use criteria in the query that filters the number values to include. That
criteria could reference a TextBox on a form so for example you enter a 3 on
a form and the query would produce 3 copies of each row and if you were to
enter a 5 you would get 5 copies.

 

[Guest]

Many thanks to that answer, that did it!
/Krille

"Rick Brandt" skrev: