8 Replies - 11787 Views - Last Post: 10 February 2010 - 04:40 AM

#1 anurag41055  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 17-January 09

Microsoft Office Access 2007 Calculation

Post icon  Posted 17 January 2009 - 01:34 AM

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
Is This A Good Question/Topic? 0
  • +

Replies To: Microsoft Office Access 2007 Calculation

#2 MRJ  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 4
  • View blog
  • Posts: 118
  • Joined: 13-October 07

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
Was This Post Helpful? 0
  • +
  • -

#3 xerxes333  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 31
  • View blog
  • Posts: 504
  • Joined: 05-July 07

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.
Was This Post Helpful? 0
  • +
  • -

#4 yobstrack  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 20-January 09

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
Was This Post Helpful? 0
  • +
  • -

#5 crummydo  Icon User is offline

  • D.I.C Head

Reputation: 5
  • View blog
  • Posts: 209
  • Joined: 06-January 09

Re: Microsoft Office Access 2007 Calculation

Posted 21 January 2009 - 11:01 PM

View Postyobstrack, 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.
Was This Post Helpful? 0
  • +
  • -

#6 yobstrack  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 20-January 09

Re: Microsoft Office Access 2007 Calculation

Posted 23 January 2009 - 01:36 AM

View Postcrummydo, on 21 Jan, 2009 - 10:01 PM, said:

View Postyobstrack, 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..
Was This Post Helpful? 0
  • +
  • -

#7 crummydo  Icon User is offline

  • D.I.C Head

Reputation: 5
  • View blog
  • Posts: 209
  • Joined: 06-January 09

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

Was This Post Helpful? 0
  • +
  • -

#8 yobstrack  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 20-January 09

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...
Was This Post Helpful? 0
  • +
  • -

#9 Guest_mike*


Reputation:

Re: Microsoft Office Access 2007 Calculation

Posted 10 February 2010 - 04:40 AM

http://www.mvps.org/...nloads/calc.zip
Was This Post Helpful? 0

Page 1 of 1