June 11, 200421 yr Newbies 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.
Create an account or sign in to comment