AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL: https://accessusergroups.org/blog/accesssqltool/
As a firm that specializes in converting Access to SQL Server, this tool will be a real time saver! But it gets better with the ability to also create a string you can paste into your code:
You can find the tool at https://accessusergroups.org/sql-converter/
Please note it’s still in BETA and we are looking for feedback, which you can provide by clicking on the feedback button. Read the post and head on over to the tool to learn more!