I have a table like:


ProjectCode, ProjectDescription, RemainingEffort, MilestoneDate, SnapshotDate

With data like:


390, XRACU@DRB0, 37, 09/17/03, 09/18/03
390, XRACU@DRB1, 37, 09/20/03, 09/18/03
390, XRACU@DRB2, 37, 09/21/03, 09/18/03
390, XRACU@DRB0, 37, 09/18/03, 09/19/03
390, XRACU@DRB1, 37, 09/21/03, 09/19/03
390, XRACU@DRB2, 37, 09/22/03, 09/19/03

I would like the recordset to be:

ProjectCode, XRACU@DRB0, XRACU@DRB0, XRACU@DRB0, SnapShotDate

Data would be:

390, 09/17/03, 09/20/03, 09/21/03, 09/18/03,
390, 09/18/03, 09/21/03, 09/22/03, 09/19/03,

Is this possible?