S
sundowner225
Could someone help me with an output problem?
I have an access database that I need to create some xls output from.
Basically, I have three tables:
Faculty_Table: Fields=ID,Name, Type, Degree, Additional Comments
Courses_Table: Fields=ID, CourseName, CourseTitle, Section
GradCourse_Table: Fields=ID, CourseName, CourseTitle, Institution
Facutly_Table holds information on faculty members
Courses_Table holds information on what classes each faculty member is
currently teaching
GradCourse_Table holds info on what graduate level courses each one has
taken to maintain teaching credentials.
All tables are linked using the ID field, so for each Faculty Member in
the Faculty_Table there are one or more records in Courses_Table and
there are 0 or more entries in the GradCourses table.
I need a report that looks something like this (just a sample)
Name|Type|Courses_Table.*|Degree|GradCourse_Table.*|AdditionalComments
I created this report by using queries on Courses_Table and
GradCourse_Table.
Those queries were showin in subreports so the visible report looks
something like this:
Name|Type|SubReportCourses|Degree|SubReportGradCourses|AdditionalComments.
Now this report is exactly what I want it to be. It displays properly
and shows each faculty member, a list of all classes they are teaching,
and a list of all grad level courses they have taken to retain their
credentials.
However, the issue comes when I try to export this report to xls.
When I try to export to xls, instead of the above, I get this:
|Name|Type|Degree|AddtionalComments|
|CoursesAssigned|
|GradCourses|
Any idea on how to customize the xls output so that the full results
from the SubReportCourses and SubReportGradCourses shows up in a single
field in the xls output?
basically, so I get a spreadsheet where each faculty member is on one
line of the spreadsheet, and in each line, there is one field that
contains multiple lines of output from the Courses_Table and one field
that contains multiple Lines of output from the GradCourses_Table?
Cheers
Jeff
I have an access database that I need to create some xls output from.
Basically, I have three tables:
Faculty_Table: Fields=ID,Name, Type, Degree, Additional Comments
Courses_Table: Fields=ID, CourseName, CourseTitle, Section
GradCourse_Table: Fields=ID, CourseName, CourseTitle, Institution
Facutly_Table holds information on faculty members
Courses_Table holds information on what classes each faculty member is
currently teaching
GradCourse_Table holds info on what graduate level courses each one has
taken to maintain teaching credentials.
All tables are linked using the ID field, so for each Faculty Member in
the Faculty_Table there are one or more records in Courses_Table and
there are 0 or more entries in the GradCourses table.
I need a report that looks something like this (just a sample)
Name|Type|Courses_Table.*|Degree|GradCourse_Table.*|AdditionalComments
I created this report by using queries on Courses_Table and
GradCourse_Table.
Those queries were showin in subreports so the visible report looks
something like this:
Name|Type|SubReportCourses|Degree|SubReportGradCourses|AdditionalComments.
Now this report is exactly what I want it to be. It displays properly
and shows each faculty member, a list of all classes they are teaching,
and a list of all grad level courses they have taken to retain their
credentials.
However, the issue comes when I try to export this report to xls.
When I try to export to xls, instead of the above, I get this:
|Name|Type|Degree|AddtionalComments|
|CoursesAssigned|
|GradCourses|
Any idea on how to customize the xls output so that the full results
from the SubReportCourses and SubReportGradCourses shows up in a single
field in the xls output?
basically, so I get a spreadsheet where each faculty member is on one
line of the spreadsheet, and in each line, there is one field that
contains multiple lines of output from the Courses_Table and one field
that contains multiple Lines of output from the GradCourses_Table?
Cheers
Jeff