Repeat detail section of report


G

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
 
Ad

Advertisements

R

Rick Brandt

Krille said:
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.
 
Ad

Advertisements

G

Guest

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

"Rick Brandt" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top