UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Graphs (bar chart) with date history    
 
   
janfolmer
post Jan 25 2006, 10:10 AM
Post #1

UtterAccess Addict
Posts: 221



I know how to create a graph, but I struggle with finding resources on the following isue.

I have a table with policies received over the year 2005. Now I want to create a graph (bar chart) with the total of sold policies per month.

Can somebody refer me to online resource, tutorials on how to do this, or help me out in some kind of creative way?

Thanks in advance
Go to the top of the page
 
+
jzwp11
post Jan 31 2006, 11:32 PM
Post #2

UtterAccess VIP
Posts: 4,236
From: Dayton, OH



You can use a query as the source of your graph (bar chart). The query may go something like this

SELECT datepart("m",tblpolicy.policydate) AS MONTH, count(tblpolicy.policyno) AS POLICIES_SOLD
FROM tblpolicy
where policydate between #01/01/2005# and #12/31/2005#
group by datepart("m",tblpolicy.policydate)

hopefully this helps
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 05:54 AM