Results 1 to 4 of 4
  1. #1
    suverman is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    15

    Box gets value from operations of other box.

    I have three box on my form, say



    AMT1, AMT2, Total.

    AMT1 is a field for input
    AMT2 is a field for input
    Total field should automatically be AMT1 + amt2.


    How should I go about in the total field? thank you.

  2. #2
    ansentry's Avatar
    ansentry is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2009
    Location
    Melbourne, Australia
    Posts
    67
    suverman,

    Have a look at the attached sample.

  3. #3
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,456
    Also look at this attachment. I took a different approach and used the table as the record source for the form. Look at the form in design view.

    Both ideas work and their use depends upon your preference.

  4. #4
    suverman is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    15
    Hey thanks a lot guys

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

Similar Threads

  1. Query to perform several special operations
    By Allison in forum Queries
    Replies: 4
    Last Post: 05-13-2011, 04:30 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
  •  
Other Forums: Microsoft Office Forums - Senior Forums