Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Formulas

Discussion in 'Information Technology' started by Judy, Jul 28, 2006.

Tags:
  1. Judy

    Judy
    Expand Collapse
    Guest

    I am trying to put in a formula that will subtract two columns... This will
    be like balancing a checkbook... that type of column entries... Please help
    me....
    Thank you
     
  2. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Create a query, after selecting the table and all the fields to be displayed,
    add another field

    Balance: [Field1Name] - [Field2Name]

    ===========================
    In SQL it will look like
    Select TableName.* , [Field1Name] - [Field2Name] As Balance From TableName

    --
    Good Luck
    BS"D


    "Judy" wrote:

    > I am trying to put in a formula that will subtract two columns... This will
    > be like balancing a checkbook... that type of column entries... Please help
    > me....
    > Thank you
     

Share This Page