Solved

# Convert Acres to hectares

Posted on 2013-12-03
475 Views
Hi I need a formula in MS Access 2010  to convert acres to  hectares
0
Question by:Taras
• 9
• 4
• 3
• +1

LVL 119

Assisted Solution

Rey Obrero earned 200 total points
you can use the conversion factor

1 acre = 0.404686 hectare

or
1 hectare = 2.47105 acres
0

LVL 18

Expert Comment

What exactly are you needing?

The general formula is hectares x 2.4711 = acres
0

LVL 61

Accepted Solution

mbizup earned 300 total points
assuming a textbox for each:

``````txtHectares =  txtAcres / 2.471
``````
0

LVL 61

Expert Comment

Or in a query...

``````UPDATE YoutTable
SET Hectares = Acres  / 2.471
``````
0

Author Comment

I am confursed I found this.

There are 0.404685642 hectares in an acre. One hectare is the area that is equal to a square of 100 meter by 100 meters and is equal to 2.47105381 acres.
0

LVL 119

Expert Comment

that is exactly what i  posted at  http:#a39694238

so if you have 100 acres
that will be equal to 40.4686 hectares
0

LVL 61

Expert Comment

<< One hectare is the area that is equal to a square of 100 meter by 100 meters and is equal to 2.47105381 acres. >>

Meaning, that if you know the number of acres and you want to get hectares, you divide the number acres by 2.471.

Hectares = acres/ 4.71   (approximately)
0

LVL 61

Expert Comment

Are you sure this is really an MS Access question?

It sounds like it would be better placed in the Math and Science Topic area for this type of discussion :-)
0

Author Comment

Yes capricorn1 you are wright.
It looks that Acres x 2.471 = Hectares
mbizup Hectare is bigger than acre, mbizup you are wrong when you said:
Meaning, that if you know the number of acres and you want to get hectares, you divide the number acres by 2.471.
It is oposite if I am not wrong.
0

LVL 61

Expert Comment

Nope...

Your question concerns Acres to Hectares.

Try this out, and enter acres in the textbox:
http://www.metric-conversions.org/area/acres-to-hectares.htm
0

LVL 119

Expert Comment

this question is an access question

poster post

Hi I need a formula in MS Access 2010  to convert acres to  hectares
0

LVL 61

Expert Comment

This is a better conversion tool, without the popups:
http://www.onlineconversion.com/area.htm

Mathematically, your trying to work this equation:

x ha = y ac

lets say for example that you have 20 acres and are trying to determine how many hectares you have.   Your equation becomes:

x ha = 20 ac   --- where x is the number of hectares you are trying to determine

We also know the unit conversion ha = 2.471 * ac ... which you can substitute for ha in the previous equation, making it:

x ( 2.471 *  ac) = 20 ac

Now you can solve for x (the number of hectares) by dividing both sides by the conversion factor:

x =  20 ac /  ( 2.471 *  ac)

the units (acres) cancel out, leaving you with x (the number of hectares):

x = 20/ 2.471

Make sense?  :-)

Lets say, for example that you have 20 acres and you want to know the number of hectares
0

LVL 61

Expert Comment

cap -

Understood - but the comments and the author's direction with this question have had nothing to do with Access specifically -- it has been about the formula (math)
0

LVL 119

Expert Comment

don't assume until you find the application that will use the formula..

could be a real estate database.
0

LVL 61

Expert Comment

Good point - It's definitely suited for the Math topic area, but It doesn't hurt to have it in both topic areas (done)
0

Author Closing Comment

thanks both of you.
0

LVL 61

Expert Comment

0

## Featured Post

### Suggested Solutions

We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …