Properly displaying record by field in a Report

#1 December 20th, 2004, 08:01 PM

I am trying yo setup a report. This report is to show all of the employees
that are enrolled in a class by Date, Instructor & Class. When I run the
report, the header only shows one of the instructors classes and the body
shows every employee even if they are being trained by a different
instructor. How can I get my report to print out the correct way and only
have the employees listed by the instructor and class they had?

#2 December 21st, 2004, 03:21 AM

Do all your records display as expected in the report's record source query?
How are you Sorting and Grouping the report records?
When you say "the header" how are we supposed to know which header?

--
Duane Hookom
MS Access MVP

"Ron" wrote in message
...
I am trying yo setup a report. This report is to show all of the employees
that are enrolled in a class by Date, Instructor & Class. When I run the
report, the header only shows one of the instructors classes and the body
shows every employee even if they are being trained by a different
instructor. How can I get my report to print out the correct way and only
have the employees listed by the instructor and class they had?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Save field value for auto insertion into new record field	Derek	Setting Up & Running Reports	4	August 15th, 2004 08:31 AM
Restrict Report To Current Record	Katherine R	Setting Up & Running Reports	1	July 15th, 2004 07:23 PM
Trouble setting unbound field on report.	I'm a Trampoline	General Discussion	4	June 23rd, 2004 06:36 AM
NUMBERING the pages	Bob	New Users	7	June 14th, 2004 12:20 AM
Last field in last record not in report...	Dr. Roberto VALENTE	Using Forms	2	May 28th, 2004 02:27 PM