My Assistant
![]() ![]() |
|
|
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 |
|
|
|
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 Top · Lo-Fi Version | Time is now: 19th June 2013 - 05:54 AM |