Prior Aid Year
Posted by jeggent on January 26, 2011
Not that I’m ever the poster boy for reliable blog posting, but I’m probably not going to be posting much until award notification go out in mid-March. I just wanted to give that warning so you don’t think the blog has been abandoned if there are a couple of weeks without an update. I do have one little PS Query trick for you today though. In creating a new Pop Select query for aid year activation I wanted to check for an award offer in the prior aid year. Sure I could have just prompted for the prior aid year and used that, but I was already prompting for the new aid year and didn’t think both should have to be entered. The solution was to use the following criteria in an “Exists” subquery:
Best of luck!