L
Lucky Man Cree
Is it possible to create the following report in Access 2000? The report
would have two instances of the same field shown on each line of the report.
That is, the report will display a single field (but different record) twice
on the same line. Every record will be paired with every other record in
the table but will not be paired with itself. That is, the report will skip
the line if both instances of the field are equal to one another. An
example of the way I'd like the report to display is shown below. In the
example, each name (Alison, Betty, Candace, Danielle, and Ellen) is a
separate record in the "names" table and query. The names are all stored in
the same "names" field and are not distinguished from each other by any
difference in level or importance. I'm not sure if this type of thing would
be called recursion.
I believe I can do this by creating a subreport but I think, with this
method, the width of the fields would be fixed and there would sometimes be
a gap between the two names. I would like the names to be concatenated so
that there would always be only a single space between them. Is this
possible?
Thanks,
Shannon
Allison Betty
Allison Candace
Allison Danielle
Allison Ellen
Betty Allison
Betty Candace
Betty Danielle
Betty Ellen
Candace Allison
Candace Betty
Candace Danielle
Candace Ellen
Danielle Allison
Danielle Betty
Danielle Candace
Danielle Ellen
Ellen Allison
Ellen Betty
Ellen Candace
Ellen Danielle
would have two instances of the same field shown on each line of the report.
That is, the report will display a single field (but different record) twice
on the same line. Every record will be paired with every other record in
the table but will not be paired with itself. That is, the report will skip
the line if both instances of the field are equal to one another. An
example of the way I'd like the report to display is shown below. In the
example, each name (Alison, Betty, Candace, Danielle, and Ellen) is a
separate record in the "names" table and query. The names are all stored in
the same "names" field and are not distinguished from each other by any
difference in level or importance. I'm not sure if this type of thing would
be called recursion.
I believe I can do this by creating a subreport but I think, with this
method, the width of the fields would be fixed and there would sometimes be
a gap between the two names. I would like the names to be concatenated so
that there would always be only a single space between them. Is this
possible?
Thanks,
Shannon
Allison Betty
Allison Candace
Allison Danielle
Allison Ellen
Betty Allison
Betty Candace
Betty Danielle
Betty Ellen
Candace Allison
Candace Betty
Candace Danielle
Candace Ellen
Danielle Allison
Danielle Betty
Danielle Candace
Danielle Ellen
Ellen Allison
Ellen Betty
Ellen Candace
Ellen Danielle