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.
2  1390 
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(FrmSelectP t) 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 "BtnOpenCha rt" 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 "FilteredPt Qry" that will have ApId,ApDate,ApS core
create a new form "frmPtChart " and inside it a line chart based on "FilteredPt Qry"
In the "FrmSelectP t" form Once you pick a Patient Id and chose the Start and End Dates clik on "btnOpenCha rt" it will opens [FrmPtChart] form and since the chart query "FilteredPtQuer y" 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
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Yisroel Markov |
last post by:
Greetings,
two of my users have the same front end db (A2K). Each of them has
created, in addition to the standard reports, a personal customized
report. Now they both want to be able to run both reports.
Is there a way I can export a report definition - not the report and
not the data - from one user to another, or do I have to manually
re-create for each guy the other guy's custom report? I know you can
do it in Crystal Reports and...
|
by: Susan |
last post by:
Word has the following method:
range.InsertSymbol 254, "Wingdings"
where 254 Wingdings is a checkbox with a check.
Is there something similar in Access for placing a checkbox with a check on
a form or report programattically by specifying 254 Wingdings?
Thanks!
Susan
|
by: Simone |
last post by:
Hi,
I'm a DB newbie and I've been having issues trying to print the record
I am viewing in a form to a report. I have looked in groups all over
and they all say to try basically the same thing but I can't get it to
work.
This is the latest code I've tried:
Private Sub NewRepairPrintPreview_Click()
|
by: duncedunce |
last post by:
Hi
Have 'googled' and no luck (after 2 hours!) - hope someone here can
help.
Access 2003
I am looking (for a visually impaired student of mine) at how to insert
unbound controls in to a form or report. I can get the field list &
toolbox visible from the view menu and I can move to the field list
|
by: ian.davies52 |
last post by:
Is there anything I can do about the apparent limit on the number of
textboxes that have calculations as their control source on a form or
report in ms-access? I have a query that pulls together all the fields
from two tables, each with about 20 fields. I then have a statistics
form that has the query as its source and the form has 273 textboxes
on, each with a calculation based on the underlying query values. The
form looks like a...
| | |
by: mgolding |
last post by:
I have an Access query that gets an ID value from an open form.
Something like
SELECT * from tablename WHERE ID=openFormName.ID;
But now, I want to also run the query by handing it the ID from a
report.
How do I set the Criteria for a query so it can take the ID value from
either the form or the report (or any source I call the query from)?
|
by: saddy |
last post by:
hello
i m using seagate crystal report and then i will use the same report in
my vb.net application
In the report i want to show the values of the table that was built in
the SQL server 2000 , a table that has 15 fields (columns) and some
10,0000 records ,the problem is that when we graphically view our
fields most of them are missing
please can anybody tell me how could i extend the graph so that we can
easily view all of our records...
|
by: sara |
last post by:
Hi -
I've looked at many posts, and cannot find the answer on this specific
problem.
I have several fields on a table, which I've defined as "Text", 3
characters, Format Yes/No (I picked up the Text and Format Yes/No from
a Posting).
I have a form with a label and a check box for each item and the user
checks off the ones s/he wants to be "Yes".
|
by: Xaysana12345 |
last post by:
Hi there,
I am having problem with form and report calculation fields showing #Num.
ex. fieldA/fieldB
if either fieldA or B=null, in the result field obtains #Num.
How can I figure out?
If either fieldA or B=0 (Null) in the result field = none (Blank) field
|
by: sarahaman |
last post by:
hi all
i am new in oracle!
i made one simple form with report and i made one print button
with trigger.(when-button-pressed)
when i press the print button so its giving me whole data,i do not want whole information of the database i want to print particular record..
some one told me use query but i do not know where i place that query.
can anyone guide me how can we display the particular data in PDF format?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
