Functions

  • Thread starter Thread starter Robert M Raley
  • Start date Start date
R

Robert M Raley

I would like to make an expression in Access 2K that
changes in cm into feet and inches. I have the expression
in Excel 2K and have converted it for use with Access.
There seems to be several problems. The formula uses the
ROUNDDOWN, INT, and CONVERT functions. I can not find
these functions in access.

Help what do I do?

Yours desperately

Bob Raley
 
disFeet: CInt([cm]/30.48)
disInch: CInt(([cm]/30.48-[disFeet])*12)

Kelvin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function CInt and Int 4
Excel How To Convert Decimal To Inches 2
Convert Cm to Feet and Inches 1
Access #Error & Excel Pivot 0
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
how do you use a function in a view (access project / adp) 7
round up and round down 8
Criteria selection 2

Back
Top