Create a report based an transposition of a table

[nmshake]

Good Morning,
I have been fighting through a problem with a database that I did not create, and I am stumped.

I have a table that is used to track receipt of a product by several different people. The table has ship dates as a primary key and yes/no check boxes as the fields for 19 columns of recipients. (like below, but with 500+ lines of data)

Date	Recipient 1	Recipient 2	Recipient 3	Recipient 4
1/1/14	x	x	x
1/15/14	x	x

A new record is added each time we ship, and the box is checked for the recipient when we receive delivery confirmation.

The current report that we are looking at has the all 19 columns for every date on the report and is really hard to red an a lot of wasted pages and ink. What I really would like to see is only those ones where the check box is "No"

Ideally the report would look like the following

Recipient	Dates Missing
Recipient 1	None (or blank)
Recipient 2	None (or blank)
Recipient 3	1/15/14
Recipient 4	1/1/14, 1/15/14

Does anyone have any thoughts on how I can accomplish this?

Thanks for your help!

(I am on access 10 32bit on a Windows 7 32 bit machine in my office)

[ranman256]

If this is a crosstab query, then you cannot predict the fields for a normal 'report'.

1. you either use the report as is was designed
RECIP1,
date
date

RECIP2
date

2. or print the crosstab as a spreadsheet as shown.

[nmshake]

I'm confused...there's no query at all, just the table and a report that was based off the table.