Hi Guys,
I’m a bit of a novice here with MS Access.
I have created a register for work that keeps track of the audits we do of security packets on the 3,800+ shelves and everything is working as it should except for archiving some data.
We need to audit all 3,800+ in one financial year. Problem is that my financial year is from 1st Oct YYYY to 30th Sept YYYY the next year. This date for the past financial year is obsoleted and we start the new year fresh again. I have fixed the problem for this year by including 30/09/2020 n to the date field in my update query, but I am going to have the same problem on 30/09/2021.
Is there any way I can tell the update query that runs continually and updates Table “Vault Audit Data” to “Shelf Audits Done” to ignore any data after 01/10/YYYY(Current Year)?
I’m a bit of a novice here with MS Access.
I have created a register for work that keeps track of the audits we do of security packets on the 3,800+ shelves and everything is working as it should except for archiving some data.
We need to audit all 3,800+ in one financial year. Problem is that my financial year is from 1st Oct YYYY to 30th Sept YYYY the next year. This date for the past financial year is obsoleted and we start the new year fresh again. I have fixed the problem for this year by including 30/09/2020 n to the date field in my update query, but I am going to have the same problem on 30/09/2021.
Is there any way I can tell the update query that runs continually and updates Table “Vault Audit Data” to “Shelf Audits Done” to ignore any data after 01/10/YYYY(Current Year)?