Charting?! (1 Viewer)

Sonya_G

New member
Local time
Today, 08:40
Joined
Oct 2, 2019
Messages
9
Hello again, I am trying to do some charting in access. 1.) I need a combo chart for the patient which tells the date of the blood pressure and the target blood pressure readings for days searched for. I tried queries. Am I expecting to much from the charts? I want to make a doctor’s report.
The chart should show:
-blood pressure.
-date.
-target blood pressure (as a line).
-patients name.
-heart rate.
 

Attachments

  • blood.zip
    107.1 KB · Views: 135

June7

AWF VIP
Local time
Today, 07:40
Joined
Mar 9, 2014
Messages
5,425
Not expecting too much. This is a fairly simple chart.

Why is date field named [time]? Better would be DateRead.

Which field would be for blood pressure?

If you want to restrict chart to a specific date period, then build a form for input of date criteria. Have the chart RowSource reference controls on form.

Bind report to table or query (SELECT DISTINCT patient_name FROM [blood pressure];) and have a textbox named tbxPatient bound to patient_name field.

Chart RowSource like:
SELECT time, Diastolic, Target, heart_rate FROM [blood pressure]
WHERE time BETWEEN Forms!Formname!Start and Forms!Formname!End AND patient_name = [tbxPatient];

Let the chart wizard build any chart then modify as needed.

Advise not to use spaces nor punctuation/special characters in naming convention. Advise not to use alias field names in tables.

Excel file not provided. Here is Access file with chart on report.
 

Attachments

  • blood1.accdb
    976 KB · Views: 126
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:40
Joined
May 7, 2009
Messages
19,175
put pb.xlsm to same folder as the sample db.
run form1.
using excel automation to create the chart.
 

Attachments

  • blood.zip
    124.6 KB · Views: 128

Users who are viewing this thread

Top Bottom