Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Specialty Columnar report help

Status
Not open for further replies.

MUtechgal

MIS
Mar 24, 2002
3
US
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?

 
You can do this without any special programming. In the Page Header create your column headers(both sets). You may have to play with your spacing a little to insure it lines up with the columns themselves. Also in the Page Header add your field that must be repeated for each page. Leave your column setup the way it is and eliminate any group headers or column headers you may have created for the columns themselves.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top