counting types of things

S

Struders

Ok i've got a problem that i'm just not able to solve, its probably somthing
really simple but i only just started using access just after christmas.
Anyway my problem,..

What i want is a report that tells me what type's and how many of each
cookie I have in each jar. I've drawen a litte quick image to show you what i
mean by that Goto www.struders.nildram.co.uk/db.jpg

The tabe i have this data in is layed out like this...

ID | Name | Cookie type | Jar
0 |Joe | cc1 | Red
1 |Jhon | cc3 | Red
2 |Adam | cc1 | Blue
3 |Tim | cc2 | Green
4 |Fred | cc3 | Blue
5 |James | cc1 | Red
6 |Bob | cc3 | Red
7 |Steve | cc1 | Blue
8 |Dan | cc2 | Green
9 |Gordan | cc2 | Blue

Now from that data i want a graph the has each Jar along the bottom with
numbers of how many cookies i have in each jar of each type.

Graph example...


cc1 cc3 cc1
_________ cc2 ____ cc2
cc3
| | | ______ |
|________
| | | | | |
| | |
_________________________________________________________
Red | Green |
Blue |

Got me ? good now, HOW THE SMEG DO I DO IT!?
 
E

Ed Warren

You must be going to the "Harry Potter" school of database design.
Your table contains no information about Number of cookes.
Without information concerning the number of cookies, you are left with
using magic to devine the results you desire.

Ed Warren.
 
S

Struders

As i said i've only started with access since just after christmas, i really
dont know what the corret way to lay it out is. the i was trying to do it
before i asked for some help was to setup a queriy with a

=count [Cookie type]

with a filter of cc1

that i think would work but i duno how to get it to filter all its doing is
counting how many rows are in the cookie type col. So if anyone knows how i
could set up that filter that would be great :).
 
Top