Linear Line in Graph

[Sr Accountant]

I am trying to create a graph for Patients per day. I would like it to graph
my current years patients per day, and then do a trend/linear line for prior
years pt's per day. Is there anyway to accomplish this using Access 2007?

Thanks in advance for your help.

 

[Duane Hookom]

Yes.

If you want a more complete response, we need to know:
- Your table(s) structure with significant fields and data types
- Explain the difference between your current and previous year's lines
- Do you want a point for each date

 

[Sr Accountant]

I have two tables, pulled into one query.

Table 1 = Current Years Pt's per Day (By month, for example: Dec 09, Jan
2010, etc.)
Table 2 = Previous Years Pt's per Day (Same format as current years)
Querty = Both Tables combined - with the relationship based on Dr # (text
field)

The difference between the current years vs previous years is exactly that:
Pt's from 2009 vs. Patients from 2010.

I would like the 2010 pt's per day (by month, per Dr #) on the report, with
a trend line showing what the 2009 pt's per day were by month, per dr #.

My report run's a lot of data by Dr # (including the graph).

If you need more clarification to help me, please let me know. Sometimes
writing this all out is hard, especially when you are a beginner at Access.

Thanks for all your help.

 

[Duane Hookom]

You would create a query to use as the graph row source like:

SELECT C.Doctor, C.Mth, C.PtsPerDay as CurrentPtsPerday, P.PtsPerDay as
PrevPtsPerday
FROM [table 1] As C join [Table 2] as P on C.Mth = P.Mth AND C.Doctor =
P.Doctor;

You can add a text box bound to Doctor in the Doctor footer (or header)
section. Then set the link master/child properties of the graph to the Doctor
field.