Newbies netcomm1 Posted June 11, 2004 Newbies Posted June 11, 2004 On a Database Record we have 12 fields where we enter the number of Hours Worked on a project for an employee. Each of the 12 fields contains the number of hours worked on a particular stage of the design process. (There are about 1500 records in this database). What I need to do is reduce the number of Stages in the design process to about 7 by combining some of the processes. So, for example we will combine Fields 1 & 2 and also Fields 7 & 8. What is the best method to use to add the "Hours Worked" in field 1 to field 2 - for all the records.
Fitch Posted June 11, 2004 Posted June 11, 2004 Create a calculated field, Sum( Field 1, Field 2 ) that's all there is to it.
Recommended Posts
This topic is 7818 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now