Results 1 to 4 of 4
  1. #1
    arthasdk is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    2

    Exclamation small help needed

    please help me with my small database



    the calculated fields in the form are not reflected in the table
    but i need them to show in table

    please see if u can help

    the accdb file is here:
    http://www.mediafire.com/?nclbiiq8q0zu41q

  2. #2
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    I don't have Access 2007/2010 here at work, so I could not open your database, but as a general rule, a calculated value should not be stored in a table, but rather, calculated on the fly when needed in forms, queries or reports.

  3. #3
    arthasdk is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    2

    sad :'(

    gah i needed formula in table

  4. #4
    Join Date
    May 2010
    Posts
    339
    Quote Originally Posted by arthasdk View Post
    gah i needed formula in table
    There is always exceptions to every rule. Maybe you could explain why you need the
    calculation to be stored instead of simply "displayed"?

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

Similar Threads

  1. Replies: 1
    Last Post: 07-14-2010, 11:55 PM
  2. Need someone to develope a small database program for me
    By Cleaner in forum Database Design
    Replies: 4
    Last Post: 10-05-2009, 07:21 AM
  3. Small Business Question
    By P5C768 in forum Access
    Replies: 1
    Last Post: 09-28-2009, 08:27 AM
  4. small if statement help please
    By taylorosso in forum Programming
    Replies: 16
    Last Post: 09-23-2009, 11:23 AM
  5. Best way to organize a small database of people?
    By Orabidoo in forum Database Design
    Replies: 1
    Last Post: 06-09-2009, 10:13 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