Data in Table not matching data in Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data not carrying over from Form to Table 3
update data in table through form 3
Auto-populate a 'Days outstanding' field 2
Help on a simple query 2
Find Bad Debtors: Show select data from query 6
Auto update date in table - not form 9
Access Default Microsoft Access Order Entry database issue 0
Access Building a IIF expression in Access 0

Back
Top