Altering Crosstab Query Data

[mightyatom13]

Is there any way to alter the data in a crosstab query? Ineed to display the data in an array by date and then create new records based on this display.

My boss is breathing down my neck on this one, so any help is appreciated.

 

[Darrylles]

Hi mighty,

Paste the query here.
To change the ouput though - first copy the query to a new name (the old one may well be still used).

Then mess with the new query. You can hack it at will without losing the original then.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[POKY]

hi

check here:

http://support.microsoft.com/support/kb/articles/Q209/1/43.asp

and here:

http://support.microsoft.com/support/kb/articles/Q209/1/41.asp

and here:

http://support.microsoft.com/support/kb/articles/Q210/0/04.asp

good luck