[AccessD] Multiple copies of value across columns in a crosstab

Hi David

I think you need to repost what the sheet should look like.

/gustav


> Picture a spreadsheet something like the following:

>                                                                      2004
> Name           PAX   DATEIN  DATEOUT  Jun-01 
> Jun-02   Jun-03   Jun-04   Jun-05   Jun-06
> Fred's 
> Tours   12    Jun-01     Jun-05          12       12       12         12 
>        12
> Bob's 
> Trips     20    Jun-03     Jun-06                               20 
> 20          20         20
> Mary's 
> Tours   41    Jun-02     Jun-05                    41       41         41 
>         41

> I have data for the first four columns in a table in a database (Name, PAX,
> DATEIN, DATEOUT)