Here is the original question where I wanted to added missing rows to the table:
But the problem is now this has to happen in access as all users are in that platform and need this to do the same thing but in access (not SQL server)
So after spending some time, I couldn’t figure it out….some TSQL stuff will not work in the access query structure…aint it?
Can anyone guide me. I have attached the access sample DB for reference as well
Within the access file – table “sheet1” is where I want to add the missed rows. Table “sheet2” has all possible week strings