COLUMNS, DATA, COMPLICATED!!!!

[dwenin]

I need to produce a report based on the 3 field: ID, Date, Activity. It need it to look like the example below. I have worked for hours to no avail. I have tried Pivot tables, which return the ID and the date information OKAY; however, I don't need totals. I have tried Crosstab query, however, I don't need a "value".
4/1/03 4/2/03 4/3/03 4/4/03 4/5/03....4/30/03
Line ID SJU SJU SJU
MIA MIA MIA
MIA MIA MIA
SJU SJU SJU

 

[psemianonymous]

Use a crosstab. Put your ID as the row header, Date as the column header, and the First([Activity]) as your value. If you don't have multiple entries for each ID/Date combination, your data should be fine that way. --
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access