Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Storing to a 'calculated' column of an MS Access table
I have a table which contains the following columns names/fields: (id, grade1, grade2, grade3, grade4, ages). Grade1 through Grade4 are of type Boolean, and ages is a String type. For a given row, the value of ages is a function of the values of grade1 through grade4, i.e., the value that is...- readams
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to store to a 'calculated' column of a MS Access table
VicM, Thank you for replying to my question. I agree with you that one should not store calculated data in a table containing the raw data from which it can be produced. However, the person I am working for wants this to be done for reasons I am not clear about - possibly so that the...- readams
- Post #3
- Forum: Microsoft: Access Other topics
-
How to store to a 'calculated' column of a MS Access table
I have an MS Access 2000 table which contains the following columns/fields: (id, grade1, grade2, grade3, grade4, ages). Grade1 through Grade4 are of type Boolean, and ages is a String type. For a given row, the value of ages is a function of the values of grade1 through grade4, i.e., the value...- readams
- Thread
- Replies: 9
- Forum: Microsoft: Access Other topics
