troubleshooting Question

Access Doable?

Avatar of Rayne
RayneFlag for United States of America asked on
Microsoft OfficeMicrosoft AccessMicrosoft SQL Server
14 Comments2 Solutions484 ViewsLast Modified:
Hello All,

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

Thank you

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros