I want To Learn How 2 Do Make Calculation (sum of 2 field) In Microsoft Office Access 2007
As We Are Doing in Ms Excel
Microsoft Office Access 2007 Calculation
Page 1 of 18 Replies - 11787 Views - Last Post: 10 February 2010 - 04:40 AM
Replies To: Microsoft Office Access 2007 Calculation
#2
Re: Microsoft Office Access 2007 Calculation
Posted 17 January 2009 - 06:23 PM
You would usually do it in a query,
To add to fields togeather you could use:
[Field1] + [Field2]
of to sum a field in every row youd do
sum([fieldname])
hopes that gives you a place to start
To add to fields togeather you could use:
[Field1] + [Field2]
of to sum a field in every row youd do
sum([fieldname])
hopes that gives you a place to start
#3
Re: Microsoft Office Access 2007 Calculation
Posted 19 January 2009 - 06:52 AM
select the cell you want the result to be displayed in. Press the "=" key then select (with your mouse) the cell of the first number you wand to add. Then press the "+" key. Then select the the cell of the second number you wish to add and press enter.
#4
Re: Microsoft Office Access 2007 Calculation
Posted 20 January 2009 - 01:36 AM
hellow guys.. can you help me about making in access using form as a simple calculator compose of 0-9, point, plus,minus,divided,multiplication,negative sign,AC, and equal?.. i dont know how to write a code in access and also i dont have idea when i start coding it.. can you send it to my email add the step or procedures doing this? this is my email yobstrack@yahoo.com... thanks for the help
#5
Re: Microsoft Office Access 2007 Calculation
Posted 21 January 2009 - 11:01 PM
yobstrack, on 20 Jan, 2009 - 12:36 AM, said:
hellow guys.. can you help me about making in access using form as a simple calculator compose of 0-9, point, plus,minus,divided,multiplication,negative sign,AC, and equal?.. i dont know how to write a code in access and also i dont have idea when i start coding it.. can you send it to my email add the step or procedures doing this? this is my email yobstrack@yahoo.com... thanks for the help
Why would you want to make a calculator in Access? Is this for a class you are taking. I have never heard of such a though. I can lead you to a video tutorial that can teach you how to make a Java calculator if you want. Its really simple to build in NetBeans using the visual building tools.
I am so perplexed by your request dude.
#6
Re: Microsoft Office Access 2007 Calculation
Posted 23 January 2009 - 01:36 AM
crummydo, on 21 Jan, 2009 - 10:01 PM, said:
yobstrack, on 20 Jan, 2009 - 12:36 AM, said:
hellow guys.. can you help me about making in access using form as a simple calculator compose of 0-9, point, plus,minus,divided,multiplication,negative sign,AC, and equal?.. i dont know how to write a code in access and also i dont have idea when i start coding it.. can you send it to my email add the step or procedures doing this? this is my email yobstrack@yahoo.com... thanks for the help
Why would you want to make a calculator in Access? Is this for a class you are taking. I have never heard of such a though. I can lead you to a video tutorial that can teach you how to make a Java calculator if you want. Its really simple to build in NetBeans using the visual building tools.
I am so perplexed by your request dude.
i use to create a form as simple calculator its posible that the code i created by using access menu i click VIEW and CODE.. i can use it for writing a code? and i dont know how to start the code? pls.. help me... thanks for the reply..
#7
Re: Microsoft Office Access 2007 Calculation
Posted 23 January 2009 - 04:20 PM
One question, why does this calculator need to be in freaking Microsoft Access? Im not an Access expert my anymeans, but I know my way around enough to make a database, but creating a calculator with it seems dumb. Is this for a school assignment? If not you should consider Java for this. I can teach you how to do that.
This post has been edited by crummydo: 23 January 2009 - 04:20 PM
#8
Re: Microsoft Office Access 2007 Calculation
Posted 23 January 2009 - 05:45 PM
yes this is for school i have been taken... any one know that it's posible to do it in access? i like to do it if posible! thanks dude for your reply...
#9 Guest_mike*
Re: Microsoft Office Access 2007 Calculation
Posted 10 February 2010 - 04:40 AM
Page 1 of 1
|
|

New Topic/Question
Reply



MultiQuote





|