Showing 2 values separated by a '/' for a field on a form

[sachinvh]

I asked a question regarding this before. There is a field let's suppose Blood pressure.The values entered are 120/80 like format. I want to extract one value like 120 from this field and 've to do some calculation.So how to extract it? Rob replied me that if I make 2 fields in a table like one representing values like 120 and other representing like 80.Then I can show one value like 120/80 in form view.I tried it using a query by assigning a field a value equal to [first field for 120] & '/' & [secone field for 80]. But nothing comes.So how to do this?

 

[Shadez]

I asked a question regarding this before. There is a field let's suppose Blood pressure.The values entered are 120/80 like format. I want to extract one value like 120 from this field and 've to do some calculation.So how to extract it? Rob replied me that if I make 2 fields in a table like one representing values like 120 and other representing like 80.Then I can show one value like 120/80 in form view.I tried it using a query by assigning a field a value equal to [first field for 120] & '/' & [secone field for 80]. But nothing comes.So how to do this?

The method you have quoted should work

but you could try setting the control scorce of the text box to

=[first field for 120] & "/" & [secone field for 80]

this should work as well