I am new to access but am well versed in Excel. I have tried to search the forums for an answer but do not see a thread for my particular question. I had written a macro in excel to complete a report. However I have since left that position they struggled with the report. Since my replacement is more versed in Access, they want me to convert my report to access. - which seemed easy enough to do. However I am having one big challenge. Calculating the time lapsed in a service.
Excel is able to identify what today is :=today() then I would subtract today from the date the service occurred, then copy that formula down to all participants.
How do I convert that calculation to access?
I have tried to create a calculated field column at the end of the data and tried to create the expression
Date() - Last Serviced date
Access keeps erroring out telling me that I can not use the Date() in a calculated field.
--HELP PLEASE---