Expression data entry?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AndrewChampion
    New Member
    • Mar 2012
    • 3

    Expression data entry?

    I have a database that records grades for students and then averages them. I need the results of the average expression to post on the table. Every other field works great. I have tried using the expression in the after update property and the before update property with no results still. I am pretty new at this and any help would be appreciated. Thank you in advance for any help you provide.
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32661

    #2
    Originally posted by Andrew
    Andrew:
    I need the results of the average expression to post on the table.
    I'm not sure that's a good idea (If you mean that exactly as expressed). It's not recemmended that you ever store data that can be calculated (See Database Normalisation and Table Structures), and tables are for storing info, not for displaying that info. If you get that mixed up then you're likely to struggle with Access.

    Comment

    Working...