Add a new column to a table that requires a calculation.

[Guest]

I have a table that I have added a new column to (Projected End Date). I need
to autopopulate this column based on data in two existing columns. (Start
Date), and (Length). So all records would populate with Start Date + Length =
Projected End Date. I already created a form that calculates this value when
a NEW record is created and then writes to the column, but how can I get the
OLD existing data on the table to populate the new column. I imagine I may be
able to do it with an Update query, but I am not sure how since I would need
it to not just find records, but calculate results and then save to a new
column? Maybe I'm wrong? Any ideas or suggestions?

Thanks!

 

[ruralguy via AccessMonster.com]

Your new field is simply storing a calculated value, which is a NoNo in RDB's
and an absolute waste of space in the table. Just calculate it in a query
every time you need it!

 

[Guest]

Will do. Thanks!

Your new field is simply storing a calculated value, which is a NoNo in RDB's
and an absolute waste of space in the table. Just calculate it in a query
every time you need it!


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com