07ddg01

^VisData:C:\DDG_VB4\32_BIT\Chaptr07\crosstab.m
File Jet Utility Preferences	Window Help
Recordset (* Dynaset	Form	C Data Control
Type: C Snapshot	Type:	C No Data Control
C Table		(* DBGrid Control

SQL Statement

□201

Filter

Refresh

Sort

	Cat	Period	Sales a
►	1	1994Q1	$37.838.00
	1	1994Q2	$26.993.50 ^—
	1	1994Q3	$23.542.25
	1	1994Q4	$22.521.25
	2	1994Q1	$12.045.60
	2	1994Q2	$13.338.65
	2	1994Q3	$16.524.20
	2	1994Q4	$15.413.05
	3	1994Q1	$18.279.80
	3	1994Q2	$21.864.43
	3	1994Q3	$24.222.35
	3	1994Q4	$20.356.29
	4	1994Q1	$24.588.40
	4	1994Q2	$27.358.20
	4	1994Q3	$32,999.60
	4	1994Q4	$39.524.60
*U_ŁL

W AllowAddNew W AllowDelete W Allo |

| N | 4 | Right Click for Data Control Properties

BeginTrans | User: admin

^ SQL Statement    00 E3

Execute	Clear	Save

SELECT Categories.[CategorylD] AS Cal,    |

Format([OrderDate],"iii^|i^,i^,\Qq^M) AS Period,

Format(S um([0 rder D elails], [U ni^Price]^x[0 rder D elails], [Q uanlity]),'    00'') AS S aleś

FROM Calegories INNER JOIN (Products INNER JOIN (Orders INNER JOIN [Order D elails] ON Orders.[OrderlD] = [Order Delails],[OrderlD]) ON Products.[ProductID] = [Order Delails],[ProductID]) ON Calegories. [CategorylD] =

Products. [Categoryl D ]

WHERE ([Orders.[OrderDate] Between «01/1/94tt And tt12/31/94tt))

GROUP BY Calegories. [CalegorylD],

Formal([0 rderD ale],' 'iro\Q q'')

d