Hello.
I am going crazy over this query. But, unfortunately, with the way it is shown below, Access will not let me add a new record to the query.
However, If I remove EITHER ONE of the Temp* tables from the query (so it looks like this):
OR LIKE THIS:
Access will let me add...