View Single Post
 
Old 09-25-2020, 02:38 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you p45cal. My first PQ solution involved 2 queries, yours is just 1. I will open and see on Monday how you did it.
Please help me understand the step by step process so I could apply it to the actual data. Where did the Table (CurrentYearRegistration) that was merged to the Source come from?
3 pm: I was able to follow through the steps until the fnLastReg. The error message says that the PQ is of lower version. Google says I must update my Excel to later version than 2013 but travel restriction is still in effect in this part of the planet.

Last edited by Marcia; 09-26-2020 at 12:05 AM.
Reply With Quote