Help with sql in msaccess 2007

[anamika_vastav]

I have columns namely:

CFDA, Date, BusinessUnit Requested Fund
120 06/01/2009 DMR anamika 1211
121 06/12/2009 ODH anamika 1212
122 06/14/2009 RAS anamika 1219

And I want results like this:

Date: 06/01/2009
CFDA 120
BusinessUnit Requested By Fund
DMR Sailaja 1211

Date: 06/12/2009
CFDA 120
BusinessUnit Requested By Fund
OBM Sailaja 1212


Date: 06/14/2009
CFDA 120
BusinessUnit Requested By Fund
DAS Sailaja 1216



This is in msacess but any sql can help. Please help?

Thanks,
Anamika

[Hack]

Moved To Database Section

[mlwonio]

You want these results in a report? Form Query?