How do I create a Excel spreadsheet from the Youth Enrollment data?
SQL to generate a “master enrollment sheet” for each club. Data collected includes: Club Id, Club Name, Member/Leader ID, Member/Leader Last Name, Member/Leader First Name, Address, City, State, Zip, Phone, Age, Birthdate, Years in 4-H, Parent Last, Parent First, School, Grade, Project ID & Project Description – Instructions, click here ****What do I do if the 237 report – lines 9, 10 & 11 do not balance? – Those of you who were not able to balance the 237 report on line 9, 10 & 11 probably have members or leaders with a invalid primary club code. To find out if this is the case run the following SQL: Go in the youth program to File – Create and View Query type in or copy and paste the following statements: select distinct youth2a.memberid, youth2a.lastname, youth2a.firstname, youth2a.clubid, youth2a.memberid + youth2a.clubid memberclub from “youth2a.db”youth2a where (youth2a.memberid + youth2a.clubid not in (select distinct youth2xl.memberid + youth2xl.clubid from “youth2xl.db”youth2x
