About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
Question I would like to determine the variance of time between entries in a database . The date field is populated every time an entry is made. I would like to use this date field to determine that variance. I familiar with Access....Thanks
Answer Hi
You could use the DateDiff() built in function.
For example,
MsgBox DateDiff("d", Now(), Now() + 7)
This statement would display a message box with the difference in days between Now() and Now()+7
If you substitute the Now constants with your values you'll get what you need.
Note: If you use VBA to declare dates remember that the format is always in American format (mm/dd/yy) regardless of your local settings.
