format access report so that records will run horizontally instead of vertically
Posted on 2010-09-13
Is there any way to format access report so that records will run horizontally instead of vertically? I am putting together a report which will appear in a book. Each ancestor has multiple children. The query behind the report looks like this:
ANCESTOR NUMBER FIRST NAME SURNAME CHILD NAME
1034 David Allen Robert
1034 David Allen John
1034 David Allen Thomas
1034 David Allen David
1034 David Allen James Joseph
1034 David Allen Mary
1034 David Allen Benjamin
1098 Richard Aycock Edward
1098 Richard Aycock Burwell
1098 Richard Aycock Henry
1098 Richard Aycock Joel
1098 Richard Aycock Rebecca
1098 Richard Aycock Richard, Jr.
1098 Richard Aycock Winifred "Polly"
1144 Roger Barton Hugh
1144 Roger Barton Clark Talbot
1144 Roger Barton Gilbert
1144 Roger Barton Armstead
They want the report to look like this in the book but showing all the children instead of just one:
ANCESTOR NUMBER List
7100 Abernathy, John Jr, (PS VA) (c1743 - c1824) Spouses: m Molly ; m c1762/65 Mary; Children: Nnancy b c1763
7101 Abernathy, John Sr, (PS VA) (1723 - 1812) Spouses: m 1744 Lucy; Children: Frederick b 1745
7102 Abney, Paul, (Pvt VA) (1755-60 - 1815) Spouses: m 1785 Rhoda; Children: Thomas b 1785
7103 Adams, Drury, (Pvt SC) (c1755 - 1814) Spouses: m Sarah; m Elizabeth; Children: Mary
7104 Adamson, Basil, (Pvt/PS MD) (1728 - 1785) Spouses: m 1747 Nancy; Children: John
I need a way to get the children records in the report to run across the page instead of the default vertical orientation.
If this is impossible, then is there a way to format a query to help make this possible.