Searching for sum of columns in Cross Tab Query

[Knelou]

I don't know much about VBA but I can have a look (is it when you import an excel datasheet in your database?) How can I let you see my data?? I tried to download my database but of course it doesn't work... How can I do?

[June7]

VBA is programming language provided with Office products.

If you want to provide db, follow instructions at bottom of my post.

[Knelou]

Database1 copy.zip Okay here you go, sorry about that, I hope it will help you... Thanks in advance !

[Knelou]

Have you succedeed June? I think I give up for this, I searched everywhere and it seems like it's not possible to be done... Anyway if you have tried something, please let me know !

[June7]

Not understanding the data. Don't have a table Bindler with TimeOfChangeover field. Why is Time field in both BindlerTimings and AllStoppageCodes? Why does code W in AllStoppageCodes not have value in Time?

[Knelou]

Yes, I am really sorry about that, there has been a problem when I saved it... Now there's not Time anymore in "All stoppage Codes" table. Everything which is important for now is in "Bindler timings & DT". I only added the data for 2 days (26/08 and 28/08). The W code should have a value in Time now. Don't look at the previous database, this new one is the one. I created a query to sum each column (for each stoppage code) such as PDT technical, PDT Process - hcangeover, PDT Process - other.... Now what I would like is to have subtotals. For example, I would like that the details of each day appears and have a subtotal of each column for the 26/08 and a subtotal for 28/08. Is this possible in a table?

Database1 copy2.zip

[Knelou]

Hi again, I tried something from my query : I createda PIVOT TABLE in "More Forms" and it really looks like as I want, nearly, because it is classified per date (in rows) and stoppage codes and the subtotals for each day can appears BUT it doesn't actually, as you can see in this screen shot. The total row for each date is empty.... How can I solve that?

[Knelou]

I am answering to myself but I FOUND IT ! Just needed to press AutoCalc in Deisgn Tab and select Sum so the subtotals appear ! I think my whole problem is solved ... (finally!) Thank you so much more your help for the previous posts June, it helped me to go on !