Full Version: Graphs (bar chart) with date history
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
janfolmer
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
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.