• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

How to update calculated field when the field is added to existing table?

How to update calculated field when the field is added to existing table?
I created a table with three fields.
One of the fields is Date Received.
I take that field to look up in another table to get a Date Due based on the number of work days.
I added the Date Due field that is filled in from the other table.
It works when I add a new record, but not for existing records.
0
Alex Campbell
Asked:
Alex Campbell
1 Solution
 
North2AlaskaCommented:
Try this:  Open manage database, locate the calculation, click Storage Options and click the "Do not store calculation results...".
0
 
Alex CampbellAuthor Commented:
Great, just what I was looking for.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now