Dear Sean Lange

Thank you for your help. I really appreciate your idea. I finally figured out 2 ways to get the job done:

Way 1:

...

Hello mister.mangoo

What I do not understand here is that I used left join here, so the total number of records from query 1 (538 records) should have been preserved. ...

Dear DAN and GRANT

Thank you for the instructions. I followed them, and finally I was successful in retrieving the data I wanted. I have another 2 questions as...

Dear Grant

Thank you very much for your help.

I tried to rerun the codes as you instructed (please see Code 3 below). However, it still gave me only records that...