Tricky Crosstab Issue

[StefanScheidegger]

Hi everybody

I have a crosstab in Access that needs to display a "running total" per day broken out by product.

The current crosstab-query that I have produced is the following:


(Product1,2+3 from the table field [product] )
___________________________________________

[Period] PRODUCT1 PRODUCT2 PRODUCT3
01.01.2003 100 400 300
02.01.2003 600 700 1100
03.01.2003 200 2400 200
etc.


The crosstab-Query that I would like to produce is this one:


PRODUCT1 PRODUCT2 PRODUCT3
01.01.2003 100 400 300
02.01.2003 700 1100 1400
03.01.2003 900 3500 1600
etc.

Do you have any ideas to do that?

Any help is appreciated. Thanks a lot for your support.

Stefan

 

[PassingBy]

Stefan
One way maybe to build another standard query using your Xtab query as the source data.

Then, using the grouping option, 'group on' the date value and sum the totals.

You could then use this 2nd query to produce whatever reports you need.

HTH

Passingby

 

[StefanScheidegger]

Thanks a lot for this idea. I have tried it. Unfortunately, the 2nd cross query did not sum up. Can you please tell me how I will be able to show the running totals (sum function; but what detail could be wrong?).

Stefan

 

[zerosandones]

Stephan,

I posted a solution for you yesterday for this exact same problem.

You responded that it worked perfectly.

What's up with posting the same post again. We're all here to help everyone with their problems, not waste our time solving the same problem for the same person several times over.

???????????????????????????