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
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.