How to Duplicate Records in a Report

[AtomicEnergy132]

I'm using Access 2007. I would like to know if it is possible to have a
single record show up twice on a report. For instance, if in my table i have:


John A 1
Mary 2
Betty B 2

I would like to have my report look like this:

*A
John

*B
Betty

*1
John

*2
Mary
Betty


where each item with a (*) is a heading for a group

Like I said, I'm not sure if this is possible, if it's not, please let me
know. Thank you all,

Dan

 

[Duane Hookom]

I expect you could create a union query like:
SELECT FieldA, FieldB as Grp
FROM tblNoName
WHERE FieldB is Not Null
UNION ALL
SELECT FieldA, FieldC
FROM tblNoName
WHERE FieldC Is Not Null;

Then create a report based on the union query and group by the Grp column.