Pivoting data in MS Access

by

You can pivot the data using TRANSFORM:

TRANSFORM COUNT(MenuItems.MealType)
SELECT April2013.SID, MenuItems.MealType
FROM April2013 
LEFT JOIN MenuItems 
  ON MenuItems.Item=April2013.Item
GROUP BY April2013.SID
PIVOT MenuItems.MealType;

More Related Contents:

  1. sql in ms-access [closed]
  2. SQL Server dynamic PIVOT query?
  3. PostgreSQL Crosstab Query
  4. Managing and debugging SQL queries in MS Access
  5. Dynamic alternative to pivot with CASE and GROUP BY
  6. How do I write a full outer join query in access
  7. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  8. SQL Server 2005 Pivot on Unknown Number of Columns
  9. Table-less UNION query in MS Access (Jet/ACE)
  10. SQL Query – Using Order By in UNION
  11. Ms Access Query: Concatenating Rows through a query
  12. Top n records per group sql in access
  13. Access-SQL: Inner Join with multiple tables
  14. Pivot Table and Concatenate Columns
  15. Address standardization within a database
  16. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  17. Dynamic Pivot Table in SQL Server
  18. Using PIVOT in SQL Server 2008
  19. Oracle Dynamic Pivoting
  20. Achieving ROW_NUMBER / PARTITION BY in MS Access
  21. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  22. SQL Updating from an inner join
  23. SQL server join tables and pivot
  24. Lightweight SQL database which doesn’t require installation [closed]
  25. Convert String to Date in MS Access Query
  26. HOW TO SELECT PREVIOUS ROW VALUE? [duplicate]
  27. MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
  28. I need to know how to create a crosstab query
  29. SQL SET DEFAULT not working in MS Access
  30. Access substitute for EXCEPT clause

Leave a Comment