Column Breaks in Reports

[jayceecindy]

I am trying to write a sales report. It should group on Salespersons name. Then going across the report show the names of the companies that the person contacted breaking on each month.

It is almost like a cross-tab query (except a list of customers instead of a count).

Jan Feb Mar Apr May
Jones CustA CustB CustD
CustC

Smith CustF CustG
CustH
CustI


Etc.

I tried using the column feature except it will not account for a blank column. I also ran into problems when I tried to use a separate subquery for each month.

Thanks in advance for your help.

Cindy