Crosstab Query Grouping

[abujafar]

In the following table I want to produce a crosstab query in access 2003 that will use the products values as the column headings. However I want condiments to display instead of pimento and cinnamon in one column, Meat instead of Beef and Chickent and Dairy instead of Milk and Cheese. These aliases are not available in any other table. How do I accomplish this in Access 2003.


Thanks in advance for any assistance. I am uploading the database with the sample table.


Products Products Code Products Quantity 001 Pimento 10 002 Cinnamon 3 003 Beef 7 004 Chicken 3 005 Milk 9 006 Cheese 11

 

[Guus2005]

Add a table "Category" with the fields Category and Products.

Then you can create any query and group them by Category.

See the modified sample

HTH

 

[abujafar]

Thanks A lot Guus2005