I have a table that is driven by due dates and would like to tack / capture the number of lates in a report or table. does anyone have any suggestions on best practices and how i might auto generate t...
I have something like this setup now and what i would like to capture is the history of lates... sorry, i dont think i spelled that out very well in my description.
How would you like to see the history? How far back do you want it to go? Are you wanting this info on the record itself(ie how many times they were late) or are you wanting to have these "late records" saved in another table somewhere, so you can associate them back to the related record and show the exact times they were late?