Diagramm mit 53 Wochen
12.06.2007 21:10:48
Brunken
aber wie läßt sich das gleiche Diagramm in Access realisieren, wenn in der DB nur Werte bis KW24
enthalten sind, dann sollen die Werte auch noch nach Kriterien abgefragt werden. Hast du eine Idee?
https://www.herber.de/bbs/user/43197.zip
ich habe es hiermit probiert, bringt mir aber nicht den gewünschten effekt.
TRANSFORM Sum(tabtest.F6) AS [Test01]
SELECT tabtest.F15 AS Ausdr1
FROM tabtest
WHERE (((Format([F3],"ww yy")) In ("1 07","2 07","3 07","4 07","5 07","6 07","7 07","8 07","9 07","10 07","11 07","12 07","13 07","14 07","15 07","16 07","17 07","18 07","19 07","20 07","21 07","22 07","23 07","24 07","25 07","26 07","27 07","28 07","29 07","30 07","31 07","32 07","33 07","34 07","35 07","36 07","37 07","38 07","39 07","40 07","41 07","42 07","43 07","44 07","45 07","46 07","47 07","48 07","49 07","50 07","51 07","52 07","53 07")) AND ((tabtest.F15)="Test"))
GROUP BY tabtest.F15
PIVOT Format(F3,"ww yy") In ("1 07","2 07","3 07","4 07","5 07","6 07","7 07","8 07","9 07","10 07","11 07","12 07","13 07","14 07","15 07","16 07","17 07","18 07","19 07","20 07","21 07","22 07","23 07","24 07","25 07","26 07","27 07","28 07","29 07","30 07","31 07","32 07","33 07","34 07","35 07","36 07","37 07","38 07","39 07","40 07","41 07","42 07","43 07","44 07","45 07","46 07","47 07","48 07","49 07","50 07","51 07","52 07","53 07");
Die Daten möchte ich über Kriterium "Test"; "Test1" usw auswählen können, dann die entsprechenden Daten und die Summe daraus errechnen (Werte dazu) für einen Bericht bzw. Formular
Wer hat eine Lösung in Access
Gruß
Erich Brunken