Multi Cross-tab Query?

[JoeyB_99]

Hi again....I sent in a question on November 5th called "tracking transactions with date-based header", with sample data.

It was promptly answered by 'pr2-eugin' and 'nanscombe' with a solution of cross-tab query using the query wizard.

Now I find out that the data - as in my previous posting - has three different quantities - planned qty, actual qty and earned qty.

How do I set up a cross-tab query here where I want the three different quantities for each cost code to appear, and the dates are the column headings?

Any help would be greatly appreciated.

 

[pbaldy]

Not sure it's the same, but I've got crosstabs where I needed to have 3 related values per person, and I was able to to run a crosstab against a union query to get it.