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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report needs grouping to list 2 records

Status
Not open for further replies.

LoriAccess

Instructor
May 21, 2007
1
US
My report of Appointments by SR (sales rep) needs to also include TM (telemarketer). I have grouped by SR as the client wants, but all the TMs appear at the end of the report. Instead I need TM to appear with related SR.
TM and SR are both records in the Type field of the Employees table. Appointment records are in the Appointments table. One Appt has many employees.
 
You could create a TM subreport and link it to the SR group detail by TM number...

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top