Results 1 to 4 of 4
  1. #1
    barakkadosh is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    5

    calculat text box and insert to field

    hii to all
    i have 1 table name "table1"
    and i have in this table 4 fields
    1) id
    2)pay
    3) tax
    4) total

    the id is praimery
    i have form
    in this form i have 3 text box "pay" "tax" "total"
    i want to insert some nomber to pay and nomber to tax and make some buton to make calculat of the 2 text box and it will show me the resoult in the total and insert them to the fields can some one help me pleas

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    Is form bound to the table? Are pay and tax bound to the fields? Total should not be saved to table. This value can be calculated whenever needed.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    barakkadosh is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    5
    how can i do it
    i am new with access
    can you explain me please

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    Do what - bind forms, bind controls, build expressions that calculate data? This is all basic Access functionality. Any introductory reference or tutorial will have guidelines as well as Access Help.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 5
    Last Post: 03-04-2012, 01:21 PM
  2. Replies: 2
    Last Post: 02-02-2012, 06:06 AM
  3. Replies: 3
    Last Post: 01-05-2012, 10:47 AM
  4. CrossTab - insert a calculated field
    By weiguo.shi in forum Queries
    Replies: 10
    Last Post: 05-23-2011, 01:20 AM
  5. Replies: 2
    Last Post: 05-05-2010, 02:52 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