asked on

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

SOLUTION

lcohan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MINDSUPERB

You may design a query from your item table similar to the image attached.

Sincerely,

Ed
coversion.PNG

SOLUTION

GrahamSkan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rayne

ASKER

where is your image?

GrahamSkan

Whose image?

Rayne

ASKER

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

MINDSUPERB

Hello Rayne,

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

Grahamskan's formula is right.

Ed

Rayne

ASKER

his image
MINDSUPERBPosted on 2014-02-04 at 10:41:33ID: 39833427

Rayne

ASKER

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

Rayne

ASKER

As some would be sold elsewhere (seven oceans away) and some will be sold nearby

GrahamSkan

It is there, called 'coversion.PNG'

ASKER CERTIFIED SOLUTION

MINDSUPERB

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rayne

ASKER

Thank you Ed :)
That works like Gold