H
Hanson
I am a beginer in MS Access. I am learning to creat a filter for crosstab
queries. This is the crosstab query from “Order table†in NORTHWIND database.
TRANSFORM Count(Orders.OrderID) AS CountOfOrderID
SELECT Orders.EmployeeID, Count(Orders.OrderID) AS [Total Of OrderID]
FROM Orders
GROUP BY Orders.EmployeeID
PIVOT Format([OrderDate],"yyyy");
Employee Total Of OrderID 1996 1997 1998
Davolio, Nancy 123 26 55 42
Fuller, Andrew 96 16 41 39
Leverling, Janet 127 18 71 38
Peacock, Margaret 156 31 81 44
Buchanan, Steven 42 11 18 13
Suyama, Michael 67 15 33 19
King, Robert 72 11 36 25
Callahan, Laura 104 19 54 31
Dodsworth, Anne 43 5 19 19
Please help me to set filter criterial: (Total Of OrderID > 100) and (years
= 1997&1998) so that the output will be:
Employee Total Of OrderID 1997 1998
Leverling, Janet 109 71 38
Peacock, Margaret 125 81 44
Thanks for your help.
queries. This is the crosstab query from “Order table†in NORTHWIND database.
TRANSFORM Count(Orders.OrderID) AS CountOfOrderID
SELECT Orders.EmployeeID, Count(Orders.OrderID) AS [Total Of OrderID]
FROM Orders
GROUP BY Orders.EmployeeID
PIVOT Format([OrderDate],"yyyy");
Employee Total Of OrderID 1996 1997 1998
Davolio, Nancy 123 26 55 42
Fuller, Andrew 96 16 41 39
Leverling, Janet 127 18 71 38
Peacock, Margaret 156 31 81 44
Buchanan, Steven 42 11 18 13
Suyama, Michael 67 15 33 19
King, Robert 72 11 36 25
Callahan, Laura 104 19 54 31
Dodsworth, Anne 43 5 19 19
Please help me to set filter criterial: (Total Of OrderID > 100) and (years
= 1997&1998) so that the output will be:
Employee Total Of OrderID 1997 1998
Leverling, Janet 109 71 38
Peacock, Margaret 125 81 44
Thanks for your help.