Probably basic, but after searching the book and the forum I am not finding the answer.  I have an Access Database that tracks jobs.  In the simplest of explanations, this is what I basically have:

 

Two tables:

 

    JOBS                             COMMENTS

 

PID (project Id #)             PID

Job Name                          Salesman

Contractor                        Comment

Bid Date                            Date

 

My report will have the Job info and an area for comments that are posted for each job.  I have multiple entries for the same PID - how do I do it???

 

 

Would like for the Comment section of the Report to look like:

 

COMMENTS:

 

07/06/09  TMB  Job going out for bid in about 30 days

07/10/09  TMB  Met with Architect today, getting specs together

07/11/09  AAF   Getting info to Estimators to get package together

 

 

Thanks in advance!!  Miki