08vcg04

% Microsoft Access

File Edit View Insert Format Records To ols Windo w Help

iH -I mm^ra|v|ftl >•] A

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

0 Crosstab 95 : Database    - !□! xl

m Tables OfP Queries j Forms ] l@ Reporls] 2 Macros] Modulesj

J

NewTable

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

11 qryCategoryByQuarter (Crosstab)

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

Open

Design

Name of food category.

;P qry Category ByQuarter (Crosstab): Crosstab Query TRANSFORM Sum([Order Details].[Unit Price]*[Order Details].[Quantity]) AS Sales SELECT Categories.[Category Name]

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/95# And #12/31/96#)) GROUP BY Categories.[Category Name]

ORDER BY Categories.[Category Name]

PIVOT Format([Order Date],"yyyy\Qq");|

[P qry Category By Quarter (Crosstab): Crosstab Query

	Category Nam	199504	199601	199602	199603	199604
►	Beverages	*547 20	*23.995.90	*24.541.50	*21.395.75	*62.395.2
	Condiments	*1.228 50	*14,427.30	*16.164.35	*13.831.15	*14.557.6
	Confections	*997.00	*23.668.05	*16.432.43	*23.081.85	*26.663.6
	Dairy Products	*1.120.80	*22,006.60	*34,059.30	*33,829.50	*42.980.6
	Grains/Cereals	*1.189.40	*14.097.80	*14.974.00	*14,297.00	*24.270.5
	Meat/Poultry	*1.988.00	*19.647.49	*12,369.90	*32.833.41	*20,673.6
	Produce	*651.00	*12.512.70	*11.362.20	*14.633.25	*17.954.4
	Seafood	*927.00	*12,074.00	*16.607.90	*25,808.80	*31.594.6

Record: H | <

1    ► I ► i I I of 8