Seperate Period Data into Fields

[JamieArvato]

Hello,

I have a table;

Period Amount Cost Centre
01 500.00 AAA
01 250.00 AAB
02 300.00 AAA
02 500.00 AAB

I want to make a report which shows a trend by period:

Cost Centre Pd01 Pd02
AAA 500.00 300.00
AAB 250.00 500.00

My problem being that the control source for Pd01 and Pd02 are the same as the way the data is held. I have overcome this before using a crosstab query but then each month the reports must be changed to add new fields for the new period available.

I'm using SQL for the record source, can anyone help ?

 

[ZmrAbdulla]

While you in the designView of the crosstab query right-click on the PERIOD field bring properties and in the column Headings enter the heading like below how you want to appear it.

"01","02","03"..........,"12"

You can't add "Pd" there, add it on the column label of the report instead.

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me