Help me please, what should I input in my query if I wanted to insert in the table the TotalNumberOfDays which is the difference of my FirstDateOccupied AND LastDateOccupied fields. I really need your help
Novice
Windows 8 
Access 2007
Help me please, what should I input in my query if I wanted to insert in the table the TotalNumberOfDays which is the difference of my FirstDateOccupied AND LastDateOccupied fields. I really need your help
Moderator
Windows XP Access 2003
You would not store a value that you can calculate whenever needed.
You run a query and use the DateDiff() function.
How to get Total Time difference between two text fields in _ _:_ _ time format
Posting Permissions
Reply With Quote