Formula to convert height from feet to inches

[difer510]

I've been trying to do this conversion by using the following expression:
Expr1: (Left([Height],InStr([Height]," ' ")-1)*12+(Right([Height],Len([Height])-InStr([Height],"'"))))
But it gives me an error message.
I need to develop an expression to calculate BMI, any suggestions?
Thanks

[jake.masters]

Could you give us some indication about what your data looks like, how it is formatted, or what the expression to calculate BMI is outside of excel?

If you could upload a sample sheet that would allow us to help you more.

[difer510]

The data is collected by entering the height in feet and inches (5' 5") and the formula to calculate
BMI = ( Weight in Pounds / ( Height in inches x Height in inches ) ) x 703
I'm trying to build this expression in Access.

I've used the following expression in Excel to do the conversion (F2 the cell where the height is located)

=LEFT(F2,FIND("'",F2)-1)*12+((MID(F2,FIND("'",F2)+1,LEN(F2)-FIND("'",F2)-1)))

[jake.masters]

Are you building this form from scratch, or has this data already been collected?

Edit*

Also, are you using access 2010/2007 or an earlier version?

[difer510]

The height and weight data are already collected in the database. I'm using a query to build that expression to create a report

[jake.masters]

I am not as familiar with the expression builder in Access as I am in Excel, and I do not want to steer you in the wrong direction. You may get more help if you reposted this in the Access Help forum. There is a guy in there named Alan who is great with Access, and he is usually online replying to people.

If you go to the main page, it is past the first box of threads. Sorry I could not be more help.

[alansidman]

Look at the attached and advise if this is what you are looking for.
Alan