janfolmer
Jan 25 2006, 10:10 AM
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
jzwp11
Jan 31 2006, 11:32 PM
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