Results 1 to 3 of 3

Mathemathical calculations in registries

  1. #1
    Cholomanchuten is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    4

    Mathemathical calculations in registries

    Hi! I understand my previous post was a wreck. I gradually understand more and more.

    Specific questions:

    (1)
    Let's say I have numeric fields A and B.
    I want, whether with a query or with an Acess functionality if such exists,
    to show the user a C field which shows the sum: "A+B" of each registry. (Not the totals, I mean a new field).
    (2)
    This is something i need to know. There is something else. Let's say i want, from the past example, the same table A,B and C. Let's say theres another field called "FORMULA". I want now Access to use that formula, user inputed, apply it to A and B and show the result in C. But the user must define what calculations must be done. Is this possible?

  2. #2
    NTC
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    1,523
    1) one can do math between fields using a Calculated Field in a query. I do not know what you mean when you refer to registries however.

    2) in general, no.
    www CahabaData com

  3. #3
    apr pillai's Avatar
    apr pillai is offline Contributor
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    134
    Your first question is not clearly understood as what you are trying to do besides finding the sum of two fields. Defining a new column in a Query can be done through VBA.

    User-defined formula with existing control values and numerical constants can be evaluated and the result can be displayed or stored in another control. Find the following Link for guidance:

    Custom Calculator and Evan Function.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calculations in a form
    By elmere in forum Forms
    Replies: 3
    Last Post: 04-27-2011, 03:11 PM
  2. Calculations in Query
    By jdhaldane in forum Queries
    Replies: 5
    Last Post: 12-10-2010, 03:57 AM
  3. time calculations
    By venu in forum Database Design
    Replies: 1
    Last Post: 10-23-2010, 11:36 AM
  4. Calculations in reports
    By bvanscoy678 in forum Reports
    Replies: 4
    Last Post: 08-05-2010, 05:27 AM
  5. subform calculations
    By genesis in forum Forms
    Replies: 0
    Last Post: 12-03-2009, 05:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums