Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002

    Unanswered: Calculating fields

    How can I add two fields together and have the result show in a third field. I need the result to be either in a table or query.

  2. #2
    Join Date
    Aug 2002
    This is the syntax for the query:

    SELECT TBLAnything.Field1, TBLAnything.Field2, [Field1]+[Field2] AS TotalOfAnything FROM TBLAnything;

    Replace TBLAnything with your table name, and Field1 with the first field, and Field2 with your second field names in this syntax. Replace TotalOfAnything with what you want to call the total. This query will return the first number, the second number, and the 2 added together.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts