Lising in report heady

[Guest]

Hi All,

I need some help with access reporting. I am trying to show a list of
clients associated to and employee. I tried doing this with a group on
clients, the user does not want to see it that way. I am not sure how to
handle listing in the report header...

Any ideas would be greatly appreciated.

Thanks,
Nats

 

[John Vinson]

Hi All,

I need some help with access reporting. I am trying to show a list of
clients associated to and employee. I tried doing this with a group on
clients, the user does not want to see it that way. I am not sure how to
handle listing in the report header...

Any ideas would be greatly appreciated.

Thanks,
Nats

Care to give us a hand here? How are you storing the clients,
employees, and their relationships in your Tables (I'd hope with a
third table related to both, but that's not clear)?

You may want a Subreport (listing all the clients) in the report
header...

John W. Vinson[MVP]

 

[Guest]

There is a 1 to many relationship between the employee and the client table.
EmployeeID is a forign key in the customer table.

My select stmt for the rpt extracts an employee and all customers associated
with that employee. When there is more that 1 customer I don't know how to
show all of the in the report header section.

Employee Name: Employee
Customers: customer1, customer2, customer3, etc

Please let me know if you need more information to help me our....

Thanks in advance.

 

[John Vinson]

My select stmt for the rpt extracts an employee and all customers associated
with that employee. When there is more that 1 customer I don't know how to
show all of the in the report header section.

Employee Name: Employee
Customers: customer1, customer2, customer3, etc

To see it as

Customers
Customer1
Customer2
Customer3

use a Subform in the header.

To see it all lined out in one field, you'll need some VBA code:
there's sample code that you can use at

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson[MVP]