I am trying to make a macro that will display the total time that a machine has been down. It will increase the total days by one until the machine has been repaired. I have a weekly report that I need to send out once a week that will display all of our machine that are down.
here are the fields that I have, Downed Machine Date, Date or Repair, and Total Days Down
currently i am using DateDiff("d",[Downed Machine Date],[Date of Repair]) to show the down time but it wont show up until the machine has been repaired. So I need to alter the code so that when the repair date is blank then the field will show how long it has been down. and once it gets repaired then it will stop adding numbers as the days pass.
Please let me know if i need to provide any more info.