X xMax Registered User. Local time Today, 08:52 Joined Aug 7, 2006 Messages 35 Jul 9, 2008 #1 I have a table with 2 Dates and an Integer. I want the Integer to be autoset to equal the amount of days between Date B and Date A. How do I do this? Max
I have a table with 2 Dates and an Integer. I want the Integer to be autoset to equal the amount of days between Date B and Date A. How do I do this? Max
pbaldy Wino Moderator Staff member Local time Today, 05:52 Joined Aug 30, 2003 Messages 36,157 Jul 9, 2008 #2 Generally you should not store a value that can be calculated from other values. In this case, simply use DateDiff in queries/forms/reports when you need the difference.
Generally you should not store a value that can be calculated from other values. In this case, simply use DateDiff in queries/forms/reports when you need the difference.
