Re: merge two field value in one field in access
As you know, Access 2013 Web App allows you to add a related item control. Unfortunately, it only allows you to display no more than 4 fields. I have found a workaround for displaying more information by adding a field to my table with Calculated data type and combining 2 or more fields into one field to display all fields. This works easily with text data type like First name, Last name, etc... but I run into an issue when I try to mix number data and text data. This table is a Vitals table and has the following number data fields:
[Weight(lbs.)]
[Height (in.)]
I would like the end result to look like this:
Weight: 100 Height: 60 BMI: 20.5
The formula to calculate the BMI is
([Weight (lbs)],10),1,4)+(703*([Weight (lbs)])/([Height (in)]*[Height (in))
I can get the correct value in a calculated field, but when I try to add a text in front of the value, I get an error, "Access couldn't convert the value from the current data type to the specified data type".
I've tried variations of substring and Right functions, but I'm missing the mark.
Any help will be appreciated. Thanks!
As you know, Access 2013 Web App allows you to add a related item control. Unfortunately, it only allows you to display no more than 4 fields. I have found a workaround for displaying more information by adding a field to my table with Calculated data type and combining 2 or more fields into one field to display all fields. This works easily with text data type like First name, Last name, etc... but I run into an issue when I try to mix number data and text data. This table is a Vitals table and has the following number data fields:
[Weight(lbs.)]
[Height (in.)]
I would like the end result to look like this:
Weight: 100 Height: 60 BMI: 20.5
The formula to calculate the BMI is
([Weight (lbs)],10),1,4)+(703*([Weight (lbs)])/([Height (in)]*[Height (in))
I can get the correct value in a calculated field, but when I try to add a text in front of the value, I get an error, "Access couldn't convert the value from the current data type to the specified data type".
I've tried variations of substring and Right functions, but I'm missing the mark.
Any help will be appreciated. Thanks!
