In an OnInsert macro I want to set a local variable to a date one day previous to the date in the current item being inserted.
Table is Absences, date field is AbsenceDate. AbsenceDate type is short date.
Variable will be used as a parameter to a Data Macro.
Retired programmer, working in SharePoint. I want to use Access Web Apps to overcome some of the functionality lacking in SharePoint. I haven't been writing code for a long time now, so there are a lot of questions.