Issue with trying to create a temp table in a query

Good morning, all!

I'm designing a report which creates multiple temp tables in the query. Unfortunately, I keep getting this error:

Here is a snippet of the query in question:

Not quite understanding what is causing the issue...... I have an earlier version of the report that is creating a single temp table, and it runs just fine.... Any thoughts as to what the issue may be?

Have a great day!

Scott