This is the first time I have tried using Access Graphs. I have a query (which runs fine) which I am trying to make into a bar graph:

SELECT Format([DateTime],"dd mmmm") AS [Contact Date], TBL_Support_Call.[Contact Source], Count(TBL_Support_Call.Ref) AS [Number of Contacts]
FROM TBL_Support_Call
WHERE (((TBL_Support_Call.DateTime)>=[Enter From Date] And (TBL_Support_Call.DateTime)<=[Enter To Date]))
GROUP BY Format([DateTime],"dd mmmm"), TBL_Support_Call.[Contact Source];

So I create a report using the query. Oh BTW the query output is:

Contact Date Contact Source Number of Contacts
05 December Email 3
05 December Intranet Form 2
05 December Phone 3
06 December Email 3
06 December Intranet Form 1
06 December Phone 2

So when running the graph wizard I selected all three fields. It didnt like this. I can get it working no trouble if I just select two of them. This makes sense as there is only an X and a Y axis.

How can I use the third?
> I want the contact date (EG '05 December') value on the X axis
> The Number of Contacts (EG '3') value on the Y axis
> And the Contact Source (EG 'Email') as bars represented by the Number of Contacts (EG '3') integer of course.

Hopefully I have explained this well enough. Normally I would create this using ASP I only ever usually use Access as a data store. Im sure what Im trying to do it easy, would appriciate assitance


Wind is your friend
Matt
www.elitemarquees.com.au

__________________
Wind is your friend
Matt

Ok I just enteredt he world of PivotCharts. I had no idea Access could do this with graphs. In my experience (which is only the last couple of hours) The graphs which are available using the graph wizard on a report can not so whta I wanted however the PivotCharts can.

Wind is your friend
Matt
www.elitemarquees.com.au