#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    2
    Rep Power
    0

    help calculating fields in Access


    Hi,

    I've just started out on Access.

    I'm wanting to take two fields in a table, 'net' and 'tax', convert 'tax' to a percent, add it to 'net' and then place the result in a 'gross' field in the same table... ??

    It's seems a simple thing to do, but I can't work out how to do it.

    Help appreciated ASAP!!

    Thankyou,

    DANIEL
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    U.S.
    Posts
    1
    Rep Power
    0

    Help Calculating


    Do you really need to store the result? It makes more sense to create the calculation on the form or report at runtime.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Arlington,Texas
    Posts
    14
    Rep Power
    0

    One Way to do it...


    Either in a query or the control sourse of a unbouned text box you can use =FormatPercent([tax])+[net] if you just have to have a field in the table you can run a update query to update the data for the gross field then use a bound text field to calculate the in coming new data.
    I hope this helps...

IMN logo majestic logo threadwatch logo seochat tools logo