Transpose table

[Guest]

Hi
I have a table which has two fields called 'Month' and 'Cost'. There are
many other fields which include 'Cost Centre' and 'Cost Code'.

What I want to do is aggregate all the 'Cost' figures which has the same
'Cost Centre' and 'Cost Code' and put them in to a field which is named after
the month as 'Jan' 'Feb' etc

Pls see the following
Current table ;
CostCentre CostCode Month Cost
c1000 E120000 Jan 2000
d2000 D340000 Feb 3000
c1000 E120000 Feb 1000

after the re-arrangement the table should look like;
CostCentre CostCode Jan Feb ..............
c1000 E120000 2000 1000
d2000 D340000 0000 3000

Can anyone suggest me how to achieve this
I cannot re-arrange the source table (which do not have primary keys) as
those are already in use and are a part of a bigger database.

Thank you in advance
Toyfixer

 

[Guest]

I think I sorted my problem. I should have read a little bit more before
posting the question. I used a crosstab query and it works fine. I applogise
for posting before reading a bit more.
Toyfixer

 

[Guest]

I've done it myself a couple of times