how can i get the output in ms access database

See more:

C#

Allotment table as follows in Ms access database

Sdate      Period  Staff
14/5/2013   1       TR
14/5/2013   2       MD
15/5/2013   1       SG
15/5/2013   2       GV

from the above Allotment table, i want the output as follows in ms access database

Sdate        Period1     Period2
14/5/2013     TR           MD
15/5/2013     SG           GV

for getting a above output how can i write the query in ms access database.

Rgds,
narasiman P.