By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Expression data entry?

P: 3
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.
Mar 10 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,308
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.
Mar 10 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.