Have special reporting needs and need assistance in figuring out how to do this.
Query pulls the necessary data by Inquiry Month.
(All people inquiring in March)
Sorting is done by Inquiry type and then name.
Need to know how to create a report that lists data in two columns.
Headers of report must span both columns.
Report and data headers example:
--LOGO--------------------------report date
---------------Name of Report -------------
[Inquiry Month]-------------Dept Signatures
-----------------------------Dept Signatures
Group/sort:Inquiry Type (Admission, Courses,etc)
Sort: Name
Example data:
ADMISSION Taggert 555-1234
Allen 555-1111
SCHEDULES
COURSES Larson 555-1444
Axel 555-1112 Mills 555-1440
Barnes 555-1113
TUITION
EOP Baxter 555-1635
Marks 555-1110 Carnes 555-1577
Stich 555-1144
At the end of column one, the data must go to column two.
Column two must then span to page two, column one, etc.
Report header MUST span both columns and be on the top
of each page.
Inquiry month (in data header) is the same for all records,
based on the query performed, and must appear at the top of each page.
I have tried, unsuccessfully, to create an Access report
that can do this. Even tried porting the data to a Word
document, with less success. I wish to avoid creating a
custom VB script to do this.
Can anyone offer some advice?
Query pulls the necessary data by Inquiry Month.
(All people inquiring in March)
Sorting is done by Inquiry type and then name.
Need to know how to create a report that lists data in two columns.
Headers of report must span both columns.
Report and data headers example:
--LOGO--------------------------report date
---------------Name of Report -------------
[Inquiry Month]-------------Dept Signatures
-----------------------------Dept Signatures
Group/sort:Inquiry Type (Admission, Courses,etc)
Sort: Name
Example data:
ADMISSION Taggert 555-1234
Allen 555-1111
SCHEDULES
COURSES Larson 555-1444
Axel 555-1112 Mills 555-1440
Barnes 555-1113
TUITION
EOP Baxter 555-1635
Marks 555-1110 Carnes 555-1577
Stich 555-1144
At the end of column one, the data must go to column two.
Column two must then span to page two, column one, etc.
Report header MUST span both columns and be on the top
of each page.
Inquiry month (in data header) is the same for all records,
based on the query performed, and must appear at the top of each page.
I have tried, unsuccessfully, to create an Access report
that can do this. Even tried porting the data to a Word
document, with less success. I wish to avoid creating a
custom VB script to do this.
Can anyone offer some advice?