Blood Pressure fields in query

[YNWA]

Hi,

I have a table that stores blood pressure reading from each contact.

Now I have to find the difference between the first reading and the last, which I can do.

Now how do I get it to show as a presentable piece of information, rather than just 2 fields that show the increase or decrease in diastolic and systolic reading?

I am trying to create an extra field in query called BloodPressure and an expression like BloodPressure[FirstBP_D],"/",[FirstBP_S]) as I want to get a reading to show in the query that resembles BP_D/BP_S, eg. 120/60, then I can do the same for the last measurements which might show 110/40.

Anyone got any ideas on the best way to do this and/or any better ways of doing it?

Cheers
Will

 

[jdraw]

Something like

Select FirstBP_D & "/" & FirstBP_S as BPForDisplay from yourTable

 

[YNWA]

Something like

Select FirstBP_D & "/" & FirstBP_S as BPForDisplay from yourTable

Cheers mate. Was a simple swap from the , to & in the end.

FirstBP: (([FirstOffldBP_D]) & "/" & ([FirstOffldBP_S]))