I have Access from Microsoft 365 and havinga query problem

I understand the SELECT error, but the rest of your reply is a little Greek to me.

Can you give me a few lines of code to explain your observation?

I am very new at this, so be patient with me, please.

Thank you for your reply

Jerry

Okay, maybe this is becoming clearer.

Please confirm: Is it the case that the entire block of text from

"SELECT [Monday Only].*,"

through the final

"MsgBox "Table '" & [Monday Only Converted] & "' created successfully!", vbInformation, "Success"

End Sub"

was originally pasted into the SQL view of a query?
And, as you said, you simply copied all of that from this SQL view to paste here?
And, to be clear, there is nothing in VBA itself? Everything shown came from a SQL view?

I repeat the questions George asked. If what you copied was from the Access SQL view, then that is your probem. Much if what you posted was VBA code, NOT SQL. Having the VBA code will definitely cause that error "Characters found after end of SQL statement."

There should be nothing before the SELECT statement and nothing after the FROM clause.

I also agree with Ken that your table structure is questionable. What is this query supposed to do and what is the app supposed to do?

I have an input form to input: First name, UTC code where they live. I also have each day of the week with an individual box for time as 00:00, 01:00, through 23:00. These boxes represent the time of day where they live, and they're available to have phone or ZOOM conferences.

I want to convert these times into universal time or world military time. Print the converted data to line up people who can meet at the same time. Like California talking to New York. In this case, we have people all over the world.

I hope this is clear. I have limited knowledge of Access Database. I have used it in the past, and I am trying to wake up my past knowledge.

Here is a picture from my PC: