08vcg01

File Edit View Insert Format Records To ols Windo w Help

m-I y| #la|y-l *1

0 Crosstab 95 : Database    - !□! xl

Ul Tables OfP Queries j Forms ] l@ Reportsj 2 Macros] Modulesj

J

NewTable

II ąryCategoryByEmployee (WHERE) H ąryCategoryByMonth (Crosstab)

H qryCategoryByQuarter (Crosstab)

H qryCategoryByQuarter (WHERE) H qryEmpl oye e ByM onth (Cro s stab) m qryOrdersByQuarter (P qry Orders By Quarter-

Open

Design | New |

[§3 qryOrdersByQuarter: Select Query

Cat

Period

►	EI3B5	199601	$23,995.90
	BEVR	199602	*24.541.50
	8EVR	199603	*21.395.75
	BEVR	199604	$62.395.25
	COND	199601	$14.427.30
	COND	199602	$16.164.35
	COND	199603	$13.831.15
	COND	199604	$14.557.85
	CONF	199601	*23.668.05
	CONF	199602	$16.432.43
	CONF	199603	*23.081.85
	CONF	199604	$26.663.39
	DAIR	199601	*22,006.60
Rt	cord: H | < |	1 ► I I I ol 32

Sales

[§3 qryOrdersByQuarter: Select Query

SELECT DISTINCTROW Categories.[Category ID] AS Cat Format([Order Date],"yyyy\Qq") AS Period, Format(Sum([Order D eta i I s] .[Unit Price]*[Order D etails].[Q ua ntity]),

"$#,##0.00") AS Sales

FROM (Categories INNER JOIN Products ON Categories.[Category ID] = Products.[Category ID]) INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.[Order ID] = [Order Details].[Order ID]) ON Products.[Product ID] = [Order Details].[Product ID]

WHERE ((Orders.[Order Datę] Between #01/1/96# And #12/31/96#)) GROUP BY Categories.[Category ID], Format([Order

Date],'Vyyy\Qq'T

WITH OWNERACCESS OPTION;

Unigue four-letter abbreviation of category n