Access 2002- default unit of measure

S

SuzieQ

I need to change the unit of measure from centimeters to inches.
Is there a way to do this within ACCESS?
 
K

KARL DEWEY

If your data is stored in centimeters and you wish to display it in inches
add a column to your query like this --
Inch Measurement: [YourField]/ 2.54
 
K

kabaka

If you change you windows settings to your desired units (either Metric or
Imperial) then Access will recognize it. Of course, this in not a solution
if you only want the change within Access. In that event, you'll just have
to code in the appropriate multiplier as the other response indicates.
 

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

Macro Loop 0
Removing a repeated words 0
Office 365 Calender 0
VBA concatenate ranges into a new document 0
Calculate the median value before a specified list 0
unit converter 3
Macro to Select text from a point given to a specific word 2
Change row height and column width values tothat of Excel for Windows 1

Top