Convert Number?

[Brook]

Good Day all..

I have a table that is used to enter the size of the product that I have
delivered. The problem is, is that the size is as a decimal.. I.E. 4.67 feet
is imported as my size, but I want to show it as 4' 8 ". Is that possible?

Thanks,

Brook

 

[Jackie L]

Brook,
This formula might look like a mess but I was trying to use this
illustration because I was assuming that digits after the decimal might not
be always 2. Note that the quote indicating the "Inches" is actually two
single quotes surrounded by double quotes.

Also, I would think you would also want to keep the original value when
importing for calculation purposes. The result below is text and has no
value. You could separate out the equation below to put the feet and inches
in separate fields and then concatenate with the quotes for reporting
purposes.

Dimension: Int([Length]) & "' " &
Int(12*(Right([Length],InStr([Length],"."))/100)) & "''"

Hope this helps. Jackie

 

[Brook]

Would I just create a new coloumn within my query and paste your code?

Thanks,

Brook

Brook,
This formula might look like a mess but I was trying to use this
illustration because I was assuming that digits after the decimal might not
be always 2. Note that the quote indicating the "Inches" is actually two
single quotes surrounded by double quotes.

Also, I would think you would also want to keep the original value when
importing for calculation purposes. The result below is text and has no
value. You could separate out the equation below to put the feet and inches
in separate fields and then concatenate with the quotes for reporting
purposes.

Dimension: Int([Length]) & "' " &
Int(12*(Right([Length],InStr([Length],"."))/100)) & "''"

Hope this helps. Jackie

Good Day all..

I have a table that is used to enter the size of the product that I have
delivered. The problem is, is that the size is as a decimal.. I.E. 4.67 feet
is imported as my size, but I want to show it as 4' 8 ". Is that possible?

Thanks,

Brook

 

[Brook]

Jackie,

One other thing, the decimal numbers will always be 2 decimal places.

hope this helps..

Brook

Brook,
This formula might look like a mess but I was trying to use this
illustration because I was assuming that digits after the decimal might not
be always 2. Note that the quote indicating the "Inches" is actually two
single quotes surrounded by double quotes.

Also, I would think you would also want to keep the original value when
importing for calculation purposes. The result below is text and has no
value. You could separate out the equation below to put the feet and inches
in separate fields and then concatenate with the quotes for reporting
purposes.

Dimension: Int([Length]) & "' " &
Int(12*(Right([Length],InStr([Length],"."))/100)) & "''"

Hope this helps. Jackie

Good Day all..

I have a table that is used to enter the size of the product that I have
delivered. The problem is, is that the size is as a decimal.. I.E. 4.67 feet
is imported as my size, but I want to show it as 4' 8 ". Is that possible?

Thanks,

Brook

 

[Jackie L]

Brook,
If the numbers to convert are always 2 decimals then your formula can look
like this:

Dimension: Int([Length]) & "' " & Int(12*(Right([Length],2))/100)) & "''"

Yes, you can add a column in your query and insert the above formula (with
your field names of course). You may have to play with whether you want your
inches result to have decimals or to be rounded up. The above example does
not put decimals in the inches and does not round.

Hope this helps. Jackie.

Jackie,

One other thing, the decimal numbers will always be 2 decimal places.

hope this helps..

Brook

Brook,
This formula might look like a mess but I was trying to use this
illustration because I was assuming that digits after the decimal might not
be always 2. Note that the quote indicating the "Inches" is actually two
single quotes surrounded by double quotes.

Also, I would think you would also want to keep the original value when
importing for calculation purposes. The result below is text and has no
value. You could separate out the equation below to put the feet and inches
in separate fields and then concatenate with the quotes for reporting
purposes.

Dimension: Int([Length]) & "' " &
Int(12*(Right([Length],InStr([Length],"."))/100)) & "''"

Hope this helps. Jackie

Good Day all..

I have a table that is used to enter the size of the product that I have
delivered. The problem is, is that the size is as a decimal.. I.E. 4.67 feet
is imported as my size, but I want to show it as 4' 8 ". Is that possible?

Thanks,

Brook

 

[Jackie L]

You will need to remove a closing parenthesis from the last example.

Jackie,

One other thing, the decimal numbers will always be 2 decimal places.

hope this helps..

Brook

Brook,
This formula might look like a mess but I was trying to use this
illustration because I was assuming that digits after the decimal might not
be always 2. Note that the quote indicating the "Inches" is actually two
single quotes surrounded by double quotes.

Also, I would think you would also want to keep the original value when
importing for calculation purposes. The result below is text and has no
value. You could separate out the equation below to put the feet and inches
in separate fields and then concatenate with the quotes for reporting
purposes.

Dimension: Int([Length]) & "' " &
Int(12*(Right([Length],InStr([Length],"."))/100)) & "''"

Hope this helps. Jackie

Good Day all..

I have a table that is used to enter the size of the product that I have
delivered. The problem is, is that the size is as a decimal.. I.E. 4.67 feet
is imported as my size, but I want to show it as 4' 8 ". Is that possible?

Thanks,

Brook