Thanks, you two!

I flipped the CROSS APPLY line and the WHERE line.

I'm so very close to having my final solution. Yea!! 😀

Now, I get an error message

...

okay, since I read the last how-to instructions, I've been trying to understand and make it work

Since my tables are live data, I don't need to create them.

Here's the code...

Thanks to everyone that has replied to me so far!

Today, during my workday, I created the attached create-table,insert-rows, and query-code TEXT file.

I've probably duplicated some of the work that...

The screen shots are from the software application.