Hello,
I am trying to delete all records within a Table greater than the date in another table. I have set the criteria to
> [Delete_SetDate].[AppDate]
The date in the table is set as 31/03/2022 - i am getting this error
if i use this criteria it works
>#31/03/2022#
But i need to have it to look up the date in the other table so i dont have to keep manually updating the delete query is this possible please?
I also have another criteria set on Product Name
Is Like "TTmaxDataServ"
I am trying to delete all records within a Table greater than the date in another table. I have set the criteria to
> [Delete_SetDate].[AppDate]
The date in the table is set as 31/03/2022 - i am getting this error
if i use this criteria it works
>#31/03/2022#
But i need to have it to look up the date in the other table so i dont have to keep manually updating the delete query is this possible please?
I also have another criteria set on Product Name
Is Like "TTmaxDataServ"