Is it possible to graph in a form rather than a report?

[abirch]

Hi all, My boss wants a graph of a person’s scale for depression (0 to 5) over the months that she sees him / her. The datta is currently stored in a table (relevant collums: ptID, date and depression). There are multiple patient IDs and I want to pull out only the data with a certain ptID and plot only those values over time, so that my boss doesn't have to look at a graph of 200 ptIDs on one sheet to find a certain person.

The only way I can figure out how to graph is with a report which lists all the patients’ depression over time. Is there any way to make a line graph of data linked to a specific patient (by ptID) in more of a form setting rather than a report, so that I could click through several graphs all specific to a certain ptID?

Thank you for any help you could give me.
Other solutions are welcome as well.
I look forward to learning from you.

[rwalle]

I would first create 2 tables 1 "TblPt" for patient data like
PtId
PtName
PtAddress
and the other for Appointments "TblAp"
that includes
ApId,
ApDate,
[Pt]LookUp field form TblPt.PtId ,
ApScore ( the depresion value assigned)

Create a Form(FrmSelectPt) with 1 CmbBox(CmbPtId) based on PtId Field from TblPt so you can chose desired PtId
also add to this form two unbound text boxes formated for date entry and named appropiately like "StrDate" and "EndDate" where you can select start and end dates ,( you should set the format of this 2 boxes to date style so you can easy enter dates, also you can set the dafault value to Now() for the EndDate and (Now()-30) for the StartDate so it will be preloaded, then add a button "BtnOpenChart" that will Open the FrmPtChart

Then create a "PtScoreQry" between 2 tables with all needed fields ApId,ApDate,Pt, ApScore,
Set the criteria for the field Pt to [Forms]![FrmSelectPt]![CmbPtId]
also set the ApDate Criteria to Between [Forms]![FrmSelectPt]![StartDate] and [Forms]![FrmSelectPt]![EndDate]

based on this query create another query "FilteredPtQry" that will have ApId,ApDate,ApScore
create a new form "frmPtChart" and inside it a line chart based on "FilteredPtQry"
In the "FrmSelectPt" form Once you pick a Patient Id and chose the Start and End Dates clik on "btnOpenChart" it will opens [FrmPtChart] form and since the chart query "FilteredPtQuery" is based on "PtScoreQry" and that is already filtered based on frmSelectPt data you will see only data for the selected Patient and in the selected date range

hope it is clear for you

BR

Raymundo Walle

[abirch]

Thank you !