{"id":1558,"date":"2020-11-13T05:51:32","date_gmt":"2020-11-13T11:51:32","guid":{"rendered":"http:\/\/accessusergroups.org\/?page_id=1558"},"modified":"2023-05-23T12:58:20","modified_gmt":"2023-05-23T17:58:20","slug":"sql-converter","status":"publish","type":"page","link":"https:\/\/accessusergroups.org\/sql-converter\/","title":{"rendered":"SQL Converter"},"content":{"rendered":"\n\n<div id=\"sqlc\" class=\"alignfull\tlight\"><!-- echo the $mode variable as class on the #sqlc wrapper -->\n\t<div class=\"container-fluid\">\n\t\t\n\t\t<form id=\"sqlc-convert-form\" method=\"post\"><!-- Form used to trigger the converter via AJAX -->\n\n\t\t\t<div id=\"sqlc-control-panel\">\n\t\t\t\t\n\t\t\t\t<div class=\"feedback\">\n\t\t\t\t\t<a href=\"#\" data-toggle=\"modal\" data-target=\"#sqlc-feedback-modal\"><i class=\"far fa-comment-alt-dots\"><\/i> Leave Feedback<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t<div class=\"title\">\n\t\t\t\t\tSQL Converter <!-- <small class=\"beta\">Beta<\/small> -->\n\t\t\t\t<\/div><!-- .title -->\n\t\t\t\t\n\t\t\t\t<div class=\"controls\">\n\t\t\t\t\t<div class=\"row\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t<div class=\"col-xl-4 col-lg-6 col-md-12\">\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"row\">\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<div class=\"col-6\">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<label for=\"sql-server-version\" class=\"select-label\">SQL Server Version<\/label>\n\t\t\t\t\t\t\t\t\t<select name=\"sql_server_version\" id=\"sql-server-version\">\n\t\t\t\t\t\t\t\t\t\t<option value=\"2008\">2008<\/option><option value=\"2012\" selected>2012<\/option><option value=\"2014\">2014<\/option><option value=\"2016\">2016<\/option><option value=\"2017\">2017<\/option><option value=\"2019\">2019<\/option>\t\t\t\t\t\t\t\t\t<\/select>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<div class=\"col-6\">\n\t\t\t\t\t\t\t\t\t<button type=\"button\" id=\"sqlc-reset\">\n\t\t\t\t\t\t\t\t\t\t<i class=\"far fa-redo\"><\/i> Reset\n\t\t\t\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t<\/div><!-- .col -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t<div class=\"col-xl-4 col-lg-6 col-md-12\">\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div id=\"sqlc-convert-wrapper\">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<button type=\"submit\" id=\"sqlc-convert\">\n\t\t\t\t\t\t\t\t\tConvert <i class=\"far fa-arrow-right\"><\/i>\n\t\t\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t<\/div><!-- .col -->\n\t\t\t\t\t\t\n\t\t\t\t\t\t<div class=\"col-xl-4 col-lg-6 col-md-12\">\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"colour-mode-toggle\">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<label class=\"toggler toggler--is-active\" id=\"toggle-light-mode\"><i class=\"fas fa-sun\"><\/i> Light mode<\/label>\n\t\t\t\t\t\t\t  <div class=\"toggle\">\n\t\t\t\t\t\t\t    <input type=\"checkbox\" id=\"switcher\" class=\"check\">\n\t\t\t\t\t\t\t    <b class=\"b switch\"><\/b>\n\t\t\t\t\t\t\t  <\/div><!-- .toggle -->\n\t\t\t\t\t\t\t  <label class=\"toggler\" id=\"toggle-dark-mode\"><i class=\"fas fa-moon\"><\/i> Dark mode<\/label>\n\t\t\t\t\t\t\t  \n\t\t\t\t\t\t\t<\/div><!-- #sqlc-colour-mode-toggle -->\n\t\t\t\t\t\t<\/div><!-- .col -->\n\t\t\t\t\t\t\n\t\t\t\t\t<\/div><!-- .row -->\n\t\t\t\t<\/div><!-- .controls -->\n\t\t\t\t\n\t\t\t<\/div><!-- #sqlc-control-panel -->\n\t\t\t\t\n\t\t\t<div class=\"row\">\t\t\t\t\n\t\t\t\t<div class=\"col-xl-6 offset-xl-3 col-lg-8 offset-lg-2 col-md-12\">\n\t\t\t\t\t<div id=\"sqlc-warnings\">\n\t\t\t\t\t\t<div class=\"alert alert-warning\" role=\"alert\">\n\t\t\t\t\t\t\tWe were unable to directly convert some of your query, please see the warnings below:\t\t\t\t\t\t\t<ul><\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div><!-- #sqlc-warnings -->\n\t\t\t\t<\/div><!-- .col -->\n\t\t\t\t\n\t\t\t\t<div class=\"col-12\">\n\t\t\t\t\t<div id=\"sqlc-code-editors\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t<div class=\"row\">\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"col-lg-6 col-md-12\">\n\t\t\t\t\t\t\t\t<div class=\"code-wrapper\">\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"code-label active\" data-target=\"access\">Access SQL<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"code-label\" data-target=\"vba-access\">VBA<\/div>\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"include-vbcrlf-wrapper vba-access\">\n\t\t\t\t\t\t\t\t\t\t<label class=\"checkbox-container\">Include vbCrLf\n\t\t\t\t              <input type=\"checkbox\" id=\"vba-access-include-vbcrlf\" class=\"include-vbcrlf\" name=\"include_vbcrlf\" data-target=\"vba-access\">\n\t\t\t\t              <span class=\"checkmark\"><\/span>\n\t\t\t\t            <\/label><!-- label.checkbox-container -->\n\t\t\t\t\t\t\t\t\t<\/div><!-- .include-vbcrlf-wrapper.vba-access -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"code-editor access\">\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t            <textarea class=\"sqlc-code\" id=\"code-access\" name=\"code_access\"><\/textarea>\n\t\t\t\t            \n\t\t\t\t            <div class=\"code-placeholder\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"far fa-code\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\tPaste your Access SQL code here.\n\t\t\t\t\t\t\t\t\t\t\t\t\t<br>Then click \"Convert\" to convert to TSQL.\n\t\t\t\t\t\t\t\t\t\t\t\t\t<br>Or, navigate to the \"VBA\" tab to see the converted VBA code.\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message -->\n\t\t\t\t\t\t\t\t\t\t<\/div><!-- .code-placeholder -->\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<div class=\"code-options\">\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"option\">\n\t\t\t\t\t\t\t\t\t\t\t\t<button type=\"button\" id=\"sqlc-access-copy\">Copy<\/button>\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .option -->\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<\/div><!-- .code-options -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div><!-- .code-editor.access -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"code-editor vba-access\">\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t            <textarea class=\"sqlc-code\" id=\"code-vba-access\" name=\"code_vba_access\"><\/textarea>\n\t\t\t            \n\t\t\t\t            <div class=\"code-placeholder\">\n\t\t\t\t\t            \n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"far fa-code\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\tYour converted VBA (Access SQL) code will appear here.\n\t\t\t\t\t\t\t\t\t\t\t\t\t<br>Paste SQL in the \"Access SQL\" tab to see the VBA version here.\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.default -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message converting\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"far fa-code\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"spinner-grow\" role=\"status\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t  <span class=\"sr-only\">Loading...<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\tConverting to VBA...\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.converting -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message error\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"fas fa-exclamation-triangle\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<strong>Error:<\/strong> We were unable to convert your query, please refresh the page and try again. If this problem persists please try again later.\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.error -->\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<\/div><!-- .code-placeholder -->\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<div class=\"code-options\">\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"option\">\n\t\t\t\t\t\t\t\t\t\t\t\t<button type=\"button\" id=\"sqlc-vba-access-copy\">Copy<\/button>\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .option -->\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<\/div><!-- .code-options -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div><!-- .code-editor.vba-access -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<\/div><!-- .code-wrapper -->\n\t\t\t\t\t\t\t<\/div><!-- .col (Access SQL) -->\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"col-lg-6 col-md-12\">\n\t\t\t\t\t\t\t\t<div class=\"code-wrapper\">\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"code-label active\" data-target=\"tsql\">TSQL<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"code-label\" data-target=\"vba-tsql\">VBA<\/div>\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"include-vbcrlf-wrapper vba-tsql\">\n\t\t\t\t\t\t\t\t\t\t<label class=\"checkbox-container\">Include vbCrLf\n\t\t\t\t              <input type=\"checkbox\" id=\"vba-tsql-include-vbcrlf\" class=\"include-vbcrlf\" name=\"include_vbcrlf\" data-target=\"vba-tsql\">\n\t\t\t\t              <span class=\"checkmark\"><\/span>\n\t\t\t\t            <\/label><!-- label.checkbox-container -->\n\t\t\t\t\t\t\t\t\t<\/div><!-- .include-vbcrlf-wrapper.vba-tsql -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"code-editor tsql\">\n\t\t\n\t\t\t\t          \t<textarea class=\"sqlc-code\" id=\"code-tsql\" name=\"code_tsql\"><\/textarea>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<div class=\"code-placeholder\">\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"far fa-code\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\tYour converted TSQL code will appear here.\n\t\t\t\t\t\t\t\t\t\t\t\t\t<br>Or, paste TSQL here and then navigate to the \"VBA\" tab to see the converted VBA code.\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.default -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message converting\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"far fa-code\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"spinner-grow\" role=\"status\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t  <span class=\"sr-only\">Loading...<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\tConverting to TSQL...\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.converting -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message error\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"fas fa-exclamation-triangle\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<strong>Error:<\/strong> We were unable to convert your query, please refresh the page and try again. If this problem persists please try again later.\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.error -->\n\n\t\t\t\t\t\t\t\t\t\t<\/div><!-- .code-placeholder -->\n\t\n\t\t\t\t\t\t\t\t\t\t<div class=\"code-options\">\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"option\">\n\t\t\t\t\t\t\t\t\t\t\t\t<button type=\"button\" id=\"sqlc-tsql-copy\">Copy<\/button>\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .option -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<!-- Juan asked for this to be removed for the time being -->\n\t\t\t\t\t\t\t\t\t\t\t<!--\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"option\">\n\t\t\t\t\t\t\t\t\t\t\t\t<button type=\"button\" id=\"sqlc-tsql-copy-formatter\">Copy & Open Formatter<\/button>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t--><!-- .option -->\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<\/div><!-- .code-options -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div><!-- .code-editor.tsql -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"code-editor vba-tsql\">\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t            <textarea class=\"sqlc-code\" id=\"code-vba-tsql\" name=\"code_vba_tsql\"><\/textarea>\n\t\t\t\t            \n\t\t\t\t            <div class=\"code-placeholder\">\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"far fa-code\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\tYour converted VBA (TSQL) code will appear here.\n\t\t\t\t\t\t\t\t\t\t\t\t\t<br>Paste SQL in the \"TSQL\" tab to see the VBA version here.\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.default -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message converting\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"far fa-code\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"spinner-grow\" role=\"status\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t  <span class=\"sr-only\">Loading...<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\tConverting to VBA...\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.converting -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"message error\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-icon-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"message-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<i class=\"fas fa-exclamation-triangle\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-icon-wrapper -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"message-text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<strong>Error:<\/strong> We were unable to convert your query, please refresh the page and try again. If this problem persists please try again later.\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message-text -->\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .message.error -->\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<\/div><!-- .code-placeholder -->\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<div class=\"code-options\">\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"option\">\n\t\t\t\t\t\t\t\t\t\t\t\t<button type=\"button\" id=\"sqlc-vba-tsql-copy\">Copy<\/button>\n\t\t\t\t\t\t\t\t\t\t\t<\/div><!-- .option -->\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t<\/div><!-- .code-options -->\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div><!-- .code-editor.vba-tsql -->\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div><!-- .col (TSQL) -->\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t<\/div><!-- .row -->\n\t\t\t\t\t<\/div><!-- #sqlc-code-editors -->\n\t\t\t\t<\/div><!-- .col -->\n\t\t\t\t\t\t\t\n\t\t\t<\/div><!-- .row -->\n\t\t\t\t\t\t\t\n\t\t\t<input type=\"hidden\" id=\"sqlc_nonce\" name=\"sqlc_nonce\" value=\"a470e5061a\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/wp-json\/wp\/v2\/pages\/1558\/\" \/>\t\t\t\n\t\t<\/form><!-- #sqlc-form-access-to-tsql -->\n\t\t\n\t\t<div id=\"sqlc-credits\">\n\t\t\tCreated by <a href=\"https:\/\/itimpact.com\" target=\"_blank\">IT Impact, Inc.<\/a><br>\n\t\t\tCode editors proudly powered by <a href=\"https:\/\/codemirror.net\/\" target=\"_blank\">Code Mirror<\/a>.<br>\n\t\t\tThis amazing tool is based on the work of Aaron Kogan and Ben Sacherich, who provided guidance, help and testing to make it happen. AUG wishes to thank them both for their time, code and efforts.\n\t\t<\/div><!-- #sqlc-credits -->\n\t\t\n\t<\/div><!-- .container-fluid -->\n\t\n\t\t\t<!-- The data-duration custom attribute is used to record how long (in milliseconds) the modal is to be displayed for -->\n\t\t<!-- This is also retrieved by jQuery to set the timeout for the modal -->\n\t\t<div class=\"modal fade\" id=\"sqlc-modal\" data-backdrop=\"static\" data-keyboard=\"false\" data-duration=\"3000\" tabindex=\"-1\" aria-labelledby=\"sqlc-modal-label\" aria-hidden=\"true\">\n\t\t  <div class=\"modal-dialog modal-dialog-centered modal-lg\">\n\t\t    <div class=\"modal-content\">\n\t\t      <div class=\"modal-body\">\n\t\t\t      <div class=\"modal-title d-flex align-items-center justify-content-center\" id=\"sqlc-modal-label\">\n\t\t\t\t      <div class=\"spinner-grow\" role=\"status\" style=\"width: 30px; height: 30px; margin-right: 5px;\">\n\t\t\t\t\t\t\t  <span class=\"sr-only\">Loading...<\/span>\n\t\t\t\t\t\t\t<\/div><!-- .spinner-grow -->\n\t\t\t\t      Converting...\n\t\t\t\t    <\/div><!-- .modal-title -->\n\t\t        <h1><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1477\" src=\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2019\/04\/logo-AUG-OK-300x83.png\" alt=\"Virtual Access User Groups\" width=\"300\" height=\"83\" srcset=\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2019\/04\/logo-AUG-OK-300x83.png 300w, https:\/\/accessusergroups.org\/wp-content\/uploads\/2019\/04\/logo-AUG-OK.png 350w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/h1>\n<h1>While you&#8217;re waiting for the conversion&#8230;<\/h1>\n<p>Consider joining us for the next LIVE Zoom group meeting, they are free and fun to attend!<\/p>\n<div class=\"aug-scroll-container\">\n<div class=\"aug-scroll-content\"><div class=\"em em-view-container\" id=\"em-view-1016418057\" data-view=\"list\">\r\n\t<div class=\"em pixelbones em-list em-events-list\" id=\"em-events-list-1016418057\" data-view-id=\"1016418057\">\r\n\t<div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">30<\/span>\n\t\t\t\t<span class=\"month\">Apr<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/lunch\/event\/access-lunchtime-4-2024-04-30\/\">Access Lunchtime - Learn how to chat with other Access developers on Discord with Jim Dettman and Doug Yudovich<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tApril 30, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t12:00 PM - 1:00 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tCome join us on the last Tuesday of every month @ 12 noon CDT.\u00a0 Maria Barnes will be your host and we will cover lots [...]\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/lunch\/event\/access-lunchtime-4-2024-04-30\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">01<\/span>\n\t\t\t\t<span class=\"month\">May<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/europe\/event\/access-europe-2024-05-01\/\">Access Europe - Adolph Dupr\u00e9 (Using  VBA to create a class based on a table)<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tMay 01, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t6:00 PM - 7:00 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tPlease join us for our monthly Access Europe session on Wed 1 May 2024 at 18:00 (6:00PM) London time (UTC+1) --------------------------------------------------------------------------------------------------------------------------------- Topic Outline: In this [...]\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/europe\/event\/access-europe-2024-05-01\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">02<\/span>\n\t\t\t\t<span class=\"month\">May<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/pacific\/event\/access-pacific-monthly-meeting-2024-05-02\/\">Developing Solid Applications with Tom van Stiphout and Kim Young<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tMay 02, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t6:30 PM - 7:30 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tPlease join us for our Monthly Chapter Presentation Thursday May 2nd, 2024 , at 6:30PM Pacific (UTC -8) Tom and Kim will draw on decades [...]\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/pacific\/event\/access-pacific-monthly-meeting-2024-05-02\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">16<\/span>\n\t\t\t\t<span class=\"month\">May<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/espana\/event\/en-desarrollo\/\">En desarrollo<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tMay 16, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t9:00 PM - 10:00 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tEn desarrollo\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/espana\/event\/en-desarrollo\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">28<\/span>\n\t\t\t\t<span class=\"month\">May<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/lunch\/event\/access-lunchtime-4-2024-05-28\/\">Access Lunchtime - Using Web APIs in Access with George Young<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tMay 28, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t12:00 PM - 1:00 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tCome join us on the last Tuesday of every month @ 12 noon CDT.\u00a0 Maria Barnes will be your host and we will cover lots [...]\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/lunch\/event\/access-lunchtime-4-2024-05-28\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">05<\/span>\n\t\t\t\t<span class=\"month\">Jun<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/europe\/event\/access-europe-2024-06-05\/\">Access Europe - Colin Riddington (View &amp; Edit Import\/Export (IMEX) Data Task Specifications)<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tJune 05, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t6:00 PM - 7:00 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tPlease join us for our monthly Access Europe session on Wed 5 June 2024 at 18:00 (6:00PM) London time (UTC+1) ---------------------------------------------------------------------------------------------------------------------------------------------------------- Further details of this [...]\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/europe\/event\/access-europe-2024-06-05\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">06<\/span>\n\t\t\t\t<span class=\"month\">Jun<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/pacific\/event\/access-pacific-monthly-meeting-2024-06-06\/\">Trouble-Shooting Access Applications with Ben Sacherich<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tJune 06, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t6:30 PM - 7:30 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tPlease join us for our Monthly Chapter Presentation June 6th, 2024 , at 6:30PM Pacific (UTC -8) You all know this story--you've lived it. Your [...]\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/pacific\/event\/access-pacific-monthly-meeting-2024-06-06\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">20<\/span>\n\t\t\t\t<span class=\"month\">Jun<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/espana\/event\/en-desarrollo-2\/\">En desarrollo<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tJune 20, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t9:00 PM - 10:00 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tEn desarrollo\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/espana\/event\/en-desarrollo-2\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">03<\/span>\n\t\t\t\t<span class=\"month\">Jul<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/europe\/event\/access-europe-2024-07-03\/\">Access Europe - Olaf N\u00f6hring (An Improved, Enhanced Message Box) \/ Andr\u00e9 Minhorst (Enhancing Access Forms)<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tJuly 03, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t6:00 PM - 7:00 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tSession outline: In this session, we will have two presenters from Germany -\u00a0Olaf N\u00f6hring\u00a0and\u00a0Andr\u00e9 Minhorst. 1. \u00a0 Getting Attention With Style - An Improved, Enhanced [...]\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/europe\/event\/access-europe-2024-07-03\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"em-event em-item \" style=\"--default-border:#_CATEGORYCOLOR;\">\n\t<div class=\"em-item-image has-placeholder\">\n\t\t\n\t\t\n\t\t<div class=\"em-item-image-placeholder\">\n\t\t\t<div class=\"date\">\n\t\t\t\t<span class=\"day\">04<\/span>\n\t\t\t\t<span class=\"month\">Jul<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<\/div>\n\t<div class=\"em-item-info\">\n\t\t<h3 class=\"em-item-title\"><a href=\"https:\/\/accessusergroups.org\/pacific\/event\/access-pacific-monthly-meeting-2024-07-04\/\">What is a Framework and Why Would Access Developers Use One? With John Colby<\/a><\/h3>\n\t\t\n\t\t<div class=\"em-event-meta em-item-meta\">\n\t\t\t<div class=\"em-item-meta-line em-event-date em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-calendar em-icon\"><\/span>\n\t\t\t\tJuly 04, 2024&nbsp;&nbsp;&nbsp;&nbsp;\n\t\t\t<\/div>\n\t\t\t<div class=\"em-item-meta-line em-event-time em-event-meta-datetime\">\n\t\t\t\t<span class=\"em-icon-clock em-icon\"><\/span>\n\t\t\t\t6:30 PM - 7:30 PM\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t<div class=\"em-item-desc\">\n\t\t\tPlease join us for our Monthly Chapter Presentation July 4, 2024, at 6:30PM Pacific (UTC -8) Check out WorldTimebuddy to determine start time for your [...]\n\t\t<\/div>\n\t\t<div class=\"em-item-actions input\">\n\t\t\t<a class=\"em-item-read-more button\" href=\"https:\/\/accessusergroups.org\/pacific\/event\/access-pacific-monthly-meeting-2024-07-04\/\">More Info<\/a>\n\t\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\t<\/div>\r\n<\/div><\/div>\n<\/div>\n\t\t      <\/div><!-- .modal-body -->\n\t\t    <\/div><!-- .modal-content -->\n\t\t  <\/div><!-- .modal-dialog -->\n\t\t<\/div><!-- #sqlc-modal.modal -->\n\t\t\n\t<div class=\"modal fade\" id=\"sqlc-feedback-modal\" data-keyboard=\"false\" tabindex=\"-1\" aria-labelledby=\"sqlc-feedback-modal-label\" aria-hidden=\"true\">\n\t  <div class=\"modal-dialog modal-dialog-centered modal-lg\">\n\t    <div class=\"modal-content\">\n\t      <div class=\"modal-body\">\n\t\t      \n\t\t\t\t\t<div id=\"sqlc-feedback-form-title\"><i class=\"far fa-comment-alt-dots\"><\/i> Leave Feedback<\/div>\n\t\t\t\t\t<div id=\"sqlc-feedback-form-description\">\n\t\t\t\t\t\tHelp us improve this tool by leaving your feedback.<br>\n\t\t\t\t\t\t<strong>\n\t\t\t\t\t\t\tPLEASE NOTE<br>\n\t\t\t\t\t\t\tThe current content of all 4 code editors on this page will be automatically sent through to us along with your details and comment below. You do not need to copy and paste your code into the comments box.\n\t\t\t\t\t\t<\/strong>\n\t\t\t\t\t<\/div>\n\t\t      \n\t\t\t\t\t<form id=\"sqlc-feedback-form\">\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t<div class=\"form-row\">\n\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t    <div class=\"form-group\">\n\t\t\t\t\t\t\t    <label for=\"sqlc-feedback-first-name\" class=\"screen-reader-text\">First name (required)<\/label>\n\t\t\t\t\t\t      <input type=\"text\" class=\"form-control\" id=\"sqlc-feedback-first-name\" name=\"sqlc_feedback_first_name\" placeholder=\"First name\" required>\n\t\t\t\t\t\t    <\/div>\n\t\t\t\t\t    <\/div>\n\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t    <div class=\"form-group\">\n\t\t\t\t\t\t\t    <label for=\"sqlc-feedback-last-name\" class=\"screen-reader-text\">Last name (required)<\/label>\n\t\t\t\t\t\t      <input type=\"text\" class=\"form-control\" id=\"sqlc-feedback-last-name\" name=\"sqlc_feedback_last_name\" placeholder=\"Last name\" required>\n\t\t\t\t\t\t    <\/div>\n\t\t\t\t\t    <\/div>\n\t\t\t\t\t  <\/div>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t    <label for=\"sqlc-feedback-email\" class=\"screen-reader-text\">Email address (required)<\/label>\n\t\t\t\t\t    <input type=\"email\" class=\"form-control\" id=\"sqlc-feedback-email\" name=\"sqlc_feedback_email\" placeholder=\"Email address\" required>\n\t\t\t\t\t  <\/div>\n\t\t\t\t\t  \n\t\t\t\t\t  <div class=\"form-group\">\n\t\t\t\t\t    <label for=\"sqlc-feedback-comment\" class=\"screen-reader-text\">Comment (required)<\/label>\n\t\t\t\t\t    <textarea class=\"form-control\" id=\"sqlc-feedback-comment\" name=\"sqlc_feedback_comment\" rows=\"6\" placeholder=\"Write your comment here...\" required><\/textarea>\n\t\t\t\t\t  <\/div>\n\t\t\t\t\t  \n\t\t\t\t\t  <div class=\"form-group\">\n\t\t\t\t\t\t  <button type=\"submit\">Submit Feedback<\/button>\n\t\t\t\t\t  <\/div>\n\t\t\t\t\t  \n\t\t\t\t\t  <textarea id=\"sqlc-feedback-access\" name=\"sqlc_feedback_access\" style=\"display: none;\"><\/textarea>\n\t\t\t\t\t  <textarea id=\"sqlc-feedback-tsql\" name=\"sqlc_feedback_tsql\" style=\"display: none;\"><\/textarea>\n\t\t\t\t\t  <textarea id=\"sqlc-feedback-vba-access\" name=\"sqlc_feedback_vba_access\" style=\"display: none;\"><\/textarea>\n\t\t\t\t\t  <textarea id=\"sqlc-feedback-vba-tsql\" name=\"sqlc_feedback_vba_tsql\" style=\"display: none;\"><\/textarea>\n\t\t\t\t\t  \n\t\t\t\t\t  <input type=\"hidden\" id=\"sqlc_feedback_nonce\" name=\"sqlc_feedback_nonce\" value=\"7611e0864d\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/wp-json\/wp\/v2\/pages\/1558\/\" \/>\t\t\t\t\t\t\n\t\t\t\t\t<\/form>\n\t\t\t\t\t\n\t\t\t\t\t<div id=\"sqlc-feedback-success\" class=\"alert alert-success\">\n\t\t\t\t\t\tThank you for submitting feedback, it has been successfully sent.\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\n\t\t\t\t\t<div id=\"sqlc-feedback-failure\" class=\"alert alert-danger\">\n\t\t\t\t\t\tWe were unable to submit your feedback. Please refresh the page and try again.\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\n\t      <\/div><!-- .modal-body -->\n\t    <\/div><!-- .modal-content -->\n\t  <\/div><!-- .modal-dialog -->\n\t<\/div><!-- #sqlc-modal.modal -->\n\t\n<\/div><!-- #sqlc -->\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Converter - AccessUserGroups.org<\/title>\n<meta name=\"description\" content=\"Convert your Access\/Jet SQL queries into T-SQL to run on Microsoft SQL Server. It supports converting the most commonly used functions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/accessusergroups.org\/sql-converter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Converter - AccessUserGroups.org\" \/>\n<meta property=\"og:description\" content=\"Convert your Access\/Jet SQL queries into T-SQL to run on Microsoft SQL Server. It supports converting the most commonly used functions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accessusergroups.org\/sql-converter\/\" \/>\n<meta property=\"og:site_name\" content=\"AccessUserGroups.org\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/AccessUserGroups\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-23T17:58:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2023\/04\/aug-share.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@AccessUserGroup\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/accessusergroups.org\/sql-converter\/\",\"url\":\"https:\/\/accessusergroups.org\/sql-converter\/\",\"name\":\"SQL Converter - AccessUserGroups.org\",\"isPartOf\":{\"@id\":\"https:\/\/accessusergroups.org\/#website\"},\"datePublished\":\"2020-11-13T11:51:32+00:00\",\"dateModified\":\"2023-05-23T17:58:20+00:00\",\"description\":\"Convert your Access\/Jet SQL queries into T-SQL to run on Microsoft SQL Server. It supports converting the most commonly used functions.\",\"breadcrumb\":{\"@id\":\"https:\/\/accessusergroups.org\/sql-converter\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accessusergroups.org\/sql-converter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accessusergroups.org\/sql-converter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accessusergroups.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Converter\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accessusergroups.org\/#website\",\"url\":\"https:\/\/accessusergroups.org\/\",\"name\":\"AccessUserGroups.org\",\"description\":\"Virtual Access User Groups\",\"publisher\":{\"@id\":\"https:\/\/accessusergroups.org\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accessusergroups.org\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/accessusergroups.org\/#organization\",\"name\":\"Access User Groups\",\"url\":\"https:\/\/accessusergroups.org\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png\",\"contentUrl\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png\",\"width\":1011,\"height\":260,\"caption\":\"Access User Groups\"},\"image\":{\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/AccessUserGroups\",\"https:\/\/twitter.com\/AccessUserGroup\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Converter - AccessUserGroups.org","description":"Convert your Access\/Jet SQL queries into T-SQL to run on Microsoft SQL Server. It supports converting the most commonly used functions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/accessusergroups.org\/sql-converter\/","og_locale":"en_US","og_type":"article","og_title":"SQL Converter - AccessUserGroups.org","og_description":"Convert your Access\/Jet SQL queries into T-SQL to run on Microsoft SQL Server. It supports converting the most commonly used functions.","og_url":"https:\/\/accessusergroups.org\/sql-converter\/","og_site_name":"AccessUserGroups.org","article_publisher":"https:\/\/www.facebook.com\/AccessUserGroups","article_modified_time":"2023-05-23T17:58:20+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2023\/04\/aug-share.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@AccessUserGroup","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/accessusergroups.org\/sql-converter\/","url":"https:\/\/accessusergroups.org\/sql-converter\/","name":"SQL Converter - AccessUserGroups.org","isPartOf":{"@id":"https:\/\/accessusergroups.org\/#website"},"datePublished":"2020-11-13T11:51:32+00:00","dateModified":"2023-05-23T17:58:20+00:00","description":"Convert your Access\/Jet SQL queries into T-SQL to run on Microsoft SQL Server. It supports converting the most commonly used functions.","breadcrumb":{"@id":"https:\/\/accessusergroups.org\/sql-converter\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accessusergroups.org\/sql-converter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/accessusergroups.org\/sql-converter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accessusergroups.org\/"},{"@type":"ListItem","position":2,"name":"SQL Converter"}]},{"@type":"WebSite","@id":"https:\/\/accessusergroups.org\/#website","url":"https:\/\/accessusergroups.org\/","name":"AccessUserGroups.org","description":"Virtual Access User Groups","publisher":{"@id":"https:\/\/accessusergroups.org\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accessusergroups.org\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/accessusergroups.org\/#organization","name":"Access User Groups","url":"https:\/\/accessusergroups.org\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/","url":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png","contentUrl":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png","width":1011,"height":260,"caption":"Access User Groups"},"image":{"@id":"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/AccessUserGroups","https:\/\/twitter.com\/AccessUserGroup"]}]}},"_links":{"self":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/pages\/1558"}],"collection":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/comments?post=1558"}],"version-history":[{"count":2,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/pages\/1558\/revisions"}],"predecessor-version":[{"id":1804,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/pages\/1558\/revisions\/1804"}],"wp:attachment":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/media?parent=1558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}