Results 1 to 2 of 2
  1. 02-04-2009, 12:15 PM #1
    FestoAccessBuilder
    FestoAccessBuilder is offline Novice
    Join Date
    Feb 2009
    Posts
    3

    Angry How can I get a calculated field to return the number back to the table?


    I have a form that has a calculated field in it is not sending the total back to the table. I have put the formula for the field in the Quary and also tried to put the formula in the Control Source of the field in the form. I need the total on the table so I can use it on a report. HELP!!!
    Reply With Quote Reply With Quote
  2. 02-05-2009, 04:53 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Try setting the field with your calculation in the BeforeUpdate event of the form.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Setting criteria in a calculated date field
    By SteveReberger in forum Access
    Replies: 0
    Last Post: 10-29-2008, 06:58 AM
  2. Text field max number as integer in sql query of MS Access
    By kamii47 in forum Queries
    Replies: 1
    Last Post: 10-09-2008, 04:48 AM
  3. Update table from calculated field in a form
    By BernardKane in forum Forms
    Replies: 3
    Last Post: 11-28-2006, 09:48 AM
  4. Calculated Text Box Populating in Table
    By Debbie in forum Access
    Replies: 2
    Last Post: 11-13-2006, 08:02 AM
  5. Concatenate two fields (text & number) for key field
    By Larry Elfenbein in forum Forms
    Replies: 2
    Last Post: 11-10-2005, 07:45 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums