Results 1 to 3 of 3
  1. #1
    ntambomvu is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Johannesburg south africa
    Posts
    91

    doing a calculation with Access

    Hello All
    some help please.
    I am writing a program using ms access.
    I need to calculate the mass of a shape and display the result to the user and then
    allow the user to use this value to calculate a price.
    This is pure arithmetric and doesnt use the data table at all
    let us presume the simple calculation of the mass of a block


    ( the mass will be length * breadth * height * specific gravity )
    therefore a form must appear asking for length,breadth,height and specific gravity.
    the operator must fill in the blanks and then the program does the calculation and displays the
    answer. then the question is asked "what price per kg ) to which the operator enters a value
    then the program calculates mass * price and displays the answer
    how would be the easiest way to code this?
    many thanks
    Fred

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Calculate in a form or a query.

    in a form, put it in a unbound textbox source to use the other textboxes to calc.

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,413
    Have a look at this.
    Just a form that allows entry of data and displays results.

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

Similar Threads

  1. calculation formulas in access
    By Hovoruha Octavian in forum Access
    Replies: 1
    Last Post: 03-19-2015, 10:18 AM
  2. Doing calculation in access
    By Johanb26 in forum Access
    Replies: 3
    Last Post: 07-25-2014, 04:21 PM
  3. Calculation Field in table vs Query calculation
    By Leonidsg in forum Database Design
    Replies: 18
    Last Post: 02-28-2013, 09:38 PM
  4. Access form calculation
    By MattyL in forum Access
    Replies: 8
    Last Post: 11-10-2011, 11:17 AM
  5. Calculation in access forms
    By miziri in forum Programming
    Replies: 13
    Last Post: 11-23-2009, 05:55 AM

Posting Permissions

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