Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 593
  • Last Modified:

Convert Acres to hectares

Hi I need a formula in MS Access 2010  to convert acres to  hectares
0
Taras
Asked:
Taras
  • 9
  • 4
  • 3
  • +1
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
you can use the conversion factor

1 acre = 0.404686 hectare

or
1 hectare = 2.47105 acres
0
 
Steven HarrisPresidentCommented:
What exactly are you needing?

The general formula is hectares x 2.4711 = acres
0
 
mbizupCommented:
assuming a textbox for each:

txtHectares =  txtAcres / 2.471 

Open in new window

0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
mbizupCommented:
Or in a query...

UPDATE YoutTable 
SET Hectares = Acres  / 2.471 

Open in new window

0
 
TarasAuthor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
that is exactly what i  posted at  http:#a39694238

so if you have 100 acres
that will be equal to 40.4686 hectares
0
 
mbizupCommented:
<< 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
 
mbizupCommented:
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
 
TarasAuthor Commented:
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
 
mbizupCommented:
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
 
Rey Obrero (Capricorn1)Commented:
this question is an access question

poster post  

Hi I need a formula in MS Access 2010  to convert acres to  hectares
0
 
mbizupCommented:
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
 
mbizupCommented:
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
 
Rey Obrero (Capricorn1)Commented:
don't assume until you find the application that will use the formula..

could be a real estate database.
0
 
mbizupCommented:
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
 
TarasAuthor Commented:
thanks both of you.
0
 
mbizupCommented:
Glad to help out :)
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 9
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now