Your Days Outstanding field in the table probably has nothing to do with the
calculated control/text box on the form. If the formula is correct, delete
that Days Outstanding field in the table and use the formula in forms,
reports, and queries to get the most accurate data. Storing a caluculated or
derived value in a table is usually a bad idea.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Casey P" wrote:
> Im am using this formula =IIf(IsNull([Complete Date]),Date()-[Order
> Date],[Complete Date]-[Order Date]) to find Days Outstanding. The form works
> great but when I pull the table up, the Days Outstanding field differs from
> the Form. So this effects my queries accuracy. Let me know if you need more
> detail.
|
Similar Threads
