Modifing an access graph to create bins

[nightf0x]

Hi guys,

I have been struggling with modifying a graph that I have made into a counting graph, I have wasted over 4 hours trying to do this modification unsuccessfully.
I am attaching 4 pictures, The Depth_Ranges Table Visual is the query which creates graph 1 you can also see in the additional attached picture of the design view the code that creates this graph 1.
Now I need to add a field in the Design view of that query in order to have a result of the graph 2 that you see in the picture.
Basically, creating counter that will count how many values are in each bin labels that you can see on the picture of graph 2.



Any help with this thing would be highly appreciated !!!

Cheers,
Daniel

[June7]

I don't understand. Looks to me like you have what you describe you want - a graph of depths and a graph of counts.

[nightf0x]

I don't understand. Looks to me like you have what you describe you want - a graph of depths and a graph of counts.

I have only the picture of the final graph which I am suppose to get which I have posted here, but I cant figure out how to get to this graph ...
I know I need to add a code to a new field to the query which will create this counting graph...

[June7]

Count is accomplished with an aggregate (GROUP BY) Totals query or a CROSSTAB query.

Click the Totals button on the ribbon to get the aggregate query grid.

Use the CROSSTAB wizard for crosstab query.

You need to calculate a field that will produce the range groups.

DepthGroup: Switch([Depth]<3, "<3", [Depth]<=4, "3 to 4", [Depth]<=5, "4 to 5", [Depth]<=6, "5 to 6", [Depth]<=7, "6 to 7", [Depth]>7, ">7")

Note that 7 cannot be in two groups.

[nightf0x]

Hey June7,

I cant seem to understand why is it [Depth]<3.... and not [Magnitude]<3 ... I am looking to find out in what bin group each of the magnitudes values is ...
Also It is suppose to be a matter of just adding a field, these are the instructions that I was given:

Add a field to the Depth_Ranges query that will assign bins to the values of Magnitude.

In your solution, did you mean I need to create a new crosstab query ??

[June7]

Okay, Magnitude.

The expression I suggest does 'add a field'. It creates a field in query. That field can be used to group data in a Totals or CROSSTAB query.