Solved

Convert Acres to hectares

Posted on 2013-12-03
18
500 Views
Last Modified: 2013-12-04
Hi I need a formula in MS Access 2010  to convert acres to  hectares
0
Comment
Question by:Taras
  • 9
  • 4
  • 3
  • +1
18 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 200 total points
ID: 39694238
you can use the conversion factor

1 acre = 0.404686 hectare

or
1 hectare = 2.47105 acres
0
 
LVL 18

Expert Comment

by:Steven Harris
ID: 39694241
What exactly are you needing?

The general formula is hectares x 2.4711 = acres
0
 
LVL 61

Accepted Solution

by:
mbizup earned 300 total points
ID: 39694242
assuming a textbox for each:

txtHectares =  txtAcres / 2.471 

Open in new window

0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 61

Expert Comment

by:mbizup
ID: 39694247
Or in a query...

UPDATE YoutTable 
SET Hectares = Acres  / 2.471 

Open in new window

0
 

Author Comment

by:Taras
ID: 39694278
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39694283
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

by:mbizup
ID: 39694291
<< 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

by:mbizup
ID: 39694293
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

by:Taras
ID: 39694420
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

by:mbizup
ID: 39694428
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39694439
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

by:mbizup
ID: 39694452
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

by:mbizup
ID: 39694457
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39694460
don't assume until you find the application that will use the formula..

could be a real estate database.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39694477
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

by:Taras
ID: 39696720
thanks both of you.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39696915
Glad to help out :)
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
Article by: Nicole
This is a research brief on the potential colonization of humans on Mars.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question