Crosstab query help!

[101287]

Can someone please help me? I have the data below and would like to have a crosstab query that generate the following results:

IST_Number Month(1) Month(2) Month(3) Month(4) ……..
3413543 195.00 210.25 355.10 450.25 …….

The data is as follows:
3413543 1 195
3413543 2 210.25
3413543 3 355.10
3413543 4 450.25
1355455 1 200.00
1355455 2 125.10

Your collaboration and guidance will be greatly appreciated.

Luis

 

[PHV]

Have you tried to follow the crosstab query wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MallardVHS]

Hi 101287,

Is this a max/min thing you're looking for?

When you get a chance, buddy, it might be helpful if you post more sample data and extended results.

Best wishes!

Don

[green]Tis far easier to keep your duck in a row if you just have the one.[/green]