I would like to subtract two date fields and use the difference for the value of another field in my table...
Example: I have one table with 3 different fields: DOD, DOA, and LOS. I want to subtract DOA from DOD and use the difference to populate the LOS field...
I have a form where the user enters the DOD and the DOA... then they click a button that takes them to another form that has the LOS text box whose control source is LOS... I want the difference to populate the LOS text box whose control source is the LOS field in my table...
This seems like such an easy thing but I can't seem to figure out where the DOD-DOA goes...
Example: I have one table with 3 different fields: DOD, DOA, and LOS. I want to subtract DOA from DOD and use the difference to populate the LOS field...
I have a form where the user enters the DOD and the DOA... then they click a button that takes them to another form that has the LOS text box whose control source is LOS... I want the difference to populate the LOS text box whose control source is the LOS field in my table...
This seems like such an easy thing but I can't seem to figure out where the DOD-DOA goes...