How To do the convert

Hello All,

I have user entering attributes of item in ft.(feet) –
How do I store values  conversion table that stores the conversion factor for the ft to meter in access?
Can someone show  a simple access  query using the user data and my conversion factor from the conversion table to show my metric in both ft and meter?

Thank you
DBConvertThis.accdb
RayneAsked:
Who is Participating?
 
MINDSUPERBConnect With a Mentor Commented:
Hello Rayne,

See the attached DB and look into the query.

Ed
DBConvertThis.accdb
0
 
lcohanConnect With a Mentor Database AnalystCommented:
You could "Add a calculated field to a table" so the value is converted as its stored in that table aside of the original value in ft (if needed as well):

http://office.microsoft.com/en-ca/access-help/add-a-calculated-field-to-a-table-HA101820564.aspx
0
 
MINDSUPERBCommented:
You may design a query from your item table similar to the image attached.

Sincerely,

Ed
coversion.PNG
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
GrahamSkanConnect With a Mentor RetiredCommented:
Not quite sure how the tables are supposed to fit together, but here is a query to select all the fields in your 'item' table plus a calculated 'metres' field.

SELECT item.ID, item.description, item.length, item.unitOfMeasure, [length]/0.3048 AS metres FROM item
0
 
RayneAuthor Commented:
where is your image?
0
 
GrahamSkanRetiredCommented:
Whose image?
0
 
RayneAuthor Commented:
Calculated fields are a step ahead…Some of good practices as folks were saying is having a unit filed as a dropdown for ft and meter and every time the data is stores, this filed must be filled. Can you show that in the attached dB? There could be more conversions than just this…so
0
 
MINDSUPERBCommented:
Hello Rayne,

You need to use: LengthInMeter: [length]/.305.

Grahamskan's formula is right.

Ed
0
 
RayneAuthor Commented:
his image
 MINDSUPERBPosted on 2014-02-04 at 10:41:33ID: 39833427
0
 
RayneAuthor Commented:
Just FYI- user will be storing data in meters for one set of items, for another set of items, they will be storing the data in feet….just to let you know
0
 
RayneAuthor Commented:
As some would be sold elsewhere (seven oceans away) and some will be sold nearby
0
 
GrahamSkanRetiredCommented:
It is there, called 'coversion.PNG'
0
 
RayneAuthor Commented:
Thank you Ed :)
That works like Gold
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.