Create Blood Pressure Field

[3063]

I am working on a database that tracks patient medical information. One of the fields, I need to create and track is blood pressure. I tried to create a field using the / symbol. Example: 140/90. One of my problems using this symbol is the field size on both sides of the / symbol may change. I also cannot figure out how to set up my query to pull information if my field is set up this way. For example, if I need to find out any patient that's blood pressure is over a certain range. Example: 140/90. Utimately, I want to put this field in a subform because it will have numerous entries in this field.

Any help will greatly be appreciated!

 

[cuok]

Hi 3063
The best I got is:
Create textBox
Set the Input Mask to: 999/999;0;-
Set the Decimal Place to : auto

if LP is less than 100 you have to lead it with zero: 92 should be 092 The leading zero will disapear on exit!

Hope its help u
CUOK

 

[danvlas]

Why not splitting it into 2 separate fields?
You will always be recording both, as far as I know...
And you can even see what's their ratio (minimum value should be some half of the maximum for an astronaut, right? )

When displaying, you can use an expression to concatenate the fields...

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[MichaelRed]

You might want to consider seperate TABLE fields for the Diastolic and Systolic values and just combine them for display.

I am diabetic and track my B.P. (several time per day), and record the readings as seperate fields. I generate a simple report (including a number of other items) for my Dr. concatenating the (B.P.) fields with the "/" as a seperator for his review / evaluation. It is very slightly awkward to 're-learn' to enter the info this way, but not a real problem.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[3063]

MichaelRed,

I tried to create a Diastolic and a Systolic field and then created a query and concatenating them. But I cannot seem to get it to work on my subform. Is it possible to build a query with this field and bring it into a subform? Or am I just missing a step somewhere or is there a better way to this? HELP!

 

[willir]

To concatenate your two numeric fields, diastolic and systolic, try

me.DisplayFld = fldDiastolic & "/" & fldSystolic

me.DisplayFld will be an unbound text field on the form.

I am not sure what your variables will be, but just use your values.

Richard

 

[3063]

If I set this up as an unbound text field in a form, can I have numerous entries? The reason I ask I want to be able to track the blood pressure over a long period time to see if there's any changes. Is there a way to this in a subform?

 

[marksnow]

Can't you just keep them as seperate text fields and have a label inbetween with "/" in it.

ie:
txt1 / txt2

You would then be able use it in your subform and be able to edit it easily.

 

[3063]

Thanks.. I tried that and it worked. I guess I was making it harder and it really is.