Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2016
    Posts
    13

    How to convert units?

    Hello everyone!

    I have a situation that I have to convert units such as Centimeters<-->Yards<-->Inches
    For specific, I have to do transactions (add or subtract) of the length of Tapes (used for garment manufacturing).
    In my mind, I think at a table level I will place a field named Remain indicating the remain of the tapes.
    And I think this field must have the default unit (centimeters for example). However in the form I want
    users to convert the units and make transactions for the desired unit.



    Someone who know how to do it please advice me.

    Thank you for answers in advance.
    AccessPractice

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In queries.
    you could make custom functions to use in the query.
    Create a vb module, in it make your functions...
    Code:
    function Inch2Cm(pvInchs)
      inch2Cm = 2.54* pvInchs
    end function
    in the query:
    select Inch2Cm([inches]) as CM from table

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Units of measure converter
    By gaker10 in forum Programming
    Replies: 5
    Last Post: 07-02-2014, 12:20 PM
  2. Display Remaining Units within time frame
    By Stanggirlie in forum Access
    Replies: 3
    Last Post: 01-05-2013, 10:44 AM
  3. Can you convert .mdb to .wdb??
    By DeeMax45 in forum Access
    Replies: 2
    Last Post: 01-22-2012, 06:11 PM
  4. Replies: 1
    Last Post: 11-02-2011, 02:18 PM
  5. Handeling Multipule Units of Measure
    By Waldenbound in forum Database Design
    Replies: 1
    Last Post: 09-02-2011, 08:24 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums