Works perfectly. Really appreciate the help you've been giving me.

The second query is named GetResult.

I would like it so that users do not have to run the query to get ValueLeft.

When I try to turn ValueLeft on Tb1 into a Lookup field and then refer to the query GetResult, I get the error: "No valid fields can be found in 'GetResult'. You may have selected a query that uses the table you're adding the lookup column to. Please select a new source."