Code:
SELECT [Contact Information].ID, [Contact Information].[Year Entered or Updated], [Contact Information].Prefix
, [Contact Information].FName, [Contact Information].LName, [Contact Information].Address, [Contact Information].City
, [Contact Information].State, [Contact Information].[Zip Code], [Contact Information].Township, [Contact Information].Phone
, [Contact Information].[E-mail]
, [Personal Information].Male, [Personal Information].Female, [Personal Information].Ethnicity
, [Personal Information].[Under 25], [Personal Information].[25-35 yrs], [Personal Information].[36-45 yrs]
, [Personal Information].[46-55 yrs], [Personal Information].[56-65 yrs], [Personal Information].[66 yrs and up]
, [Personal Information].[Not Given]
, [Work Information].Employer, [Work Information].[Type of Business], [Work Information].[Position/Title]
, [Work Information].[Work Not Given]
, [Work/Professional Skills].Agriculture, [Work/Professional Skills].Business, [Work/Professional Skills].Clergy
, [Work/Professional Skills].Education, [Work/Professional Skills].Finance, [Work/Professional Skills].Fundraising
, [Work/Professional Skills].Government, [Work/Professional Skills].[Human Resources], [Work/Professional Skills].Legal
, [Work/Professional Skills].Nonprofit, [Work/Professional Skills].Other, [Work/Professional Skills].[Other Text]
, [Work/Professional Skills].[Work Skills Not Given]
, [Relevant Experience].[Nonprofit Board], [Relevant Experience].[RE Fundraising], [Relevant Experience].[Grant Writing]
, [Relevant Experience].[RE Other], [Relevant Experience].[Other Text]
, [Time to Give].[1-2 hrs], [Time to Give].[3-5 hrs]
, [Time to Give].[6+ hrs], [Time to Give].[Time Not Given]
, Notes.Notes
, [Areas of Expertise & Talent].Administration, [Areas of Expertise & Talent].[ET Agriculture]
, [Areas of Expertise & Talent].Audit, [Areas of Expertise & Talent].[Business Management]
, [Areas of Expertise & Talent].Construction, [Areas of Expertise & Talent].[ET Education]
, [Areas of Expertise & Talent].[Event Planning], [Areas of Expertise & Talent].[Facilities Maintenance]
, [Areas of Expertise & Talent].[ET Finance], [Areas of Expertise & Talent].[ET Grant Writing]
, [Areas of Expertise & Talent].Investment, [Areas of Expertise & Talent].IT, [Areas of Expertise & Talent].[ET Legal]
, [Areas of Expertise & Talent].Marketing, [Areas of Expertise & Talent].[Nonprofit Board Service]
, [Areas of Expertise & Talent].[Public Speaking], [Areas of Expertise & Talent].[Strategic Planning]
, [Areas of Expertise & Talent].[ET Other], [Areas of Expertise & Talent].[Other Text]
, [Areas of Expertise & Talent].[ET Not Given]
, [Areas of Interest].Activities, [Areas of Interest].[Addiction/Substance Abuse], [Areas of Interest].[AI Agriculture]
, [Areas of Interest].[Animal Welfare], [Areas of Interest].Arts, [Areas of Interest].[Child Abuse/Neglect]
, [Areas of Interest].[Conservation/Wildlife], [Areas of Interest].[Culture/Museum]
, [Areas of Interest].Daycare, [Areas of Interest].[Disaster Relief], [Areas of Interest].[Diversity]
, [Areas of Interest].[Domestic Violence/Abuse], [Areas of Interest].[Economic Development]
, [Areas of Interest].[AI Education], [Areas of Interest].[Elderly/Aged], [Areas of Interest].ESL
, [Areas of Interest].[Environment/Water Quality], [Areas of Interest].[Financial Literacy]
, [Areas of Interest].[Genealogy/Historic Preservation], [Areas of Interest].[AI Government], [Areas of Interest].[Grant Maker]
, [Areas of Interest].[Group Homes], [Areas of Interest].[Health/Wellness], [Areas of Interest].Healthcare
, [Areas of Interest].Homelessness, [Areas of Interest].[Hospice/Palliative], [Areas of Interest].Leadership
, [Areas of Interest].[Library Services], [Areas of Interest].Literacy, [Areas of Interest].[Low income housing]
, [Areas of Interest].[Mental Health], [Areas of Interest].Mentoring, [Areas of Interest].[Missions/Ministry/Outreach]
, [Areas of Interest].[Parks & Rec], [Areas of Interest].[Physical/Mental Disabilities]
, [Areas of Interest].[Poverty/Self-Sufficiency], [Areas of Interest].[Public Transportation]
, [Areas of Interest].[Teen Preg/Adoption], [Areas of Interest].Therapy, [Areas of Interest].Tolerance
, [Areas of Interest].Tourism, [Areas of Interest].[AI Other], [Areas of Interest].[Other Text]
, [Areas of Interest].[AI Not Given]
, [Relevant Experience].[RE Not Given]
, [Personal Information].Visionary, [Personal Information].[Strategic Thinker], [Personal Information].Entrepreneurial
, [Personal Information].[Detail Oriented], [Personal Information].[High Energy], [Personal Information].[Low Key]
, [Personal Information].[PC Other], [Personal Information].[Other Text], [Personal Information].[PC Not Given]
, [Areas of Expertise & Talent].[ET Not Used]
, [Relevant Experience].[RE Not Used]
, [Work/Professional Skills].[Skills Merged]
, [Personal Information].Male, [Personal Information].Female
FROM ((((((([Contact Information]
INNER JOIN [Areas of Expertise & Talent] ON [Contact Information].ID = [Areas of Expertise & Talent].ID)
INNER JOIN [Areas of Interest] ON [Contact Information].ID = [Areas of Interest].ID)
INNER JOIN Notes ON [Contact Information].ID = Notes.ID)
INNER JOIN [Personal Information] ON [Contact Information].ID = [Personal Information].ID)
INNER JOIN [Relevant Experience] ON [Contact Information].ID = [Relevant Experience].ID)
INNER JOIN [Time to Give] ON [Contact Information].ID = [Time to Give].ID)
INNER JOIN [Work Information] ON [Contact Information].ID = [Work Information].ID)
INNER JOIN [Work/Professional Skills] ON [Contact Information].ID = [Work/Professional Skills].ID;
Comment