Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 7th, 2008, 11:00 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default Access and Graphs

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
 
Old December 8th, 2008, 12:15 AM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
How can show graphs in MS Access form ayazhoda Access VBA 20 April 23rd, 2007 06:50 AM
Graphs in Forms Bob Gambles VB How-To 1 July 12th, 2005 01:49 PM
Graphs jieli1001 ASP.NET 1.0 and 1.1 Professional 4 August 1st, 2003 06:23 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.