Too many crosstab column headers.

[constantG]

My database is designed for the following purpose.

I am in the Navy and when my vessel goes to sea each person receives telegrams from family and friends. Each gram must be sequentially numbered and distributed. It also has a crosstab query function that tells the user

a. When each person last received a gram
b. If a person hasn't received a gram in the last 13 days.

The crosstab query column header is the gram number and as I have just found out, once this number reaches 390 (I'm guessing here) it runs out of space and returns the error "Too many crosstab column headers".

I understand why this is happening and I'm wondering if there is a solution to my problem.

If it means going back to the drawing board, I am willing to learn.

 

[DCrake]

I think you need to reverse you rows and columns. The item that returns the most number of items should be the row heading and the outcomes should be the columns.

David

 

[constantG]

Thanks DCrake,

I think I got it sorted, instead of having the number in the column value, I placed the date each was received in the column. I wont be able to see it working until tomorrow (I tested it on a copy of the original database) but, as the database will not be used for more than 100 days at a time I cannot see any problem doing it this way.

Regards,

CW