tables for a chart 2

[peljo]

I want to build a chart for the movement of the blood pressue during the day for a month,s period.I want to use the Access chart.Does anybody have an idea how to build the tables for this curve? My idea is to have one table called BP where to get the bllod pressrue values.This table will consist of BPID,BPValue,and DayID, to be connected with another tables for the months.The table months should consist of Dayid.
Am i on the right way,and does anybody has another suggestion for the selection of the tables for this purpose.
For example :
9 oclock 140
11 oclock 160
14 oclokc 180
16 ocloc 135
Also is there any ready made example for medical charts where i can get an idea?

 

[SkipVought]

Hi,

I happen to record and plot by BP. I use Excel, however the table design should be similar.

My Columns are:
Date/Time
Systolic
Diastolic


Skip,

_{[red]Be Advised![/red] Coeds studying ancient Egyptian plumbing, might be known as...
Pharaoh Faucet Majors}

 

[dhookom]

Apparently Skip has the exact same answer I gave to this question in the public Access news groups....

It isn't clear whether you are keeping BPs for just one person or more?
Also, BPs usually have 2 values. Are you keeping both values? Apparently you are doing these by times so you should store the date and time you take the reading.

tblBPs
==================
PersonID
TakenDateTime
Systolic
Diastolic

If the table is for only one person, you could get rid of the PersonID. I normally add an autonumber primary key field to all my tables.

If this is the only function you need to do, you might consider using Excel rather than Access.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[peljo]

Thank you for your replies.How could i differentiate between dates and hours? There is only one field in your proposal date/time ?

 

[SkipVought]

Why?

It would be like having separate columns for dollars and cents.

But if you wish, have a column for date and one for time.

Skip,

_{[red]Be Advised![/red] Coeds studying ancient Egyptian plumbing, might be known as...
Pharaoh Faucet Majors}