Z
zufie
I found that the my reports are only totaling the fields for the first
record so I must modify or create another query to resolve this.
How do I fix this?
The information for the queries and reports are entered on subforms.
Here is my query behind the report Life Smart For Women:
SELECT [Tbl Main ID].[Program Name], Sum([Tbl Age].[Q1 18 - 24 Years])
AS [SumOfQ1 18 - 24 Years], Sum([Tbl Age].[Q1 25 - 44 Years]) AS
[SumOfQ1 25 - 44 Years], Sum([Tbl Age].[Q1 45 - 64 Years]) AS [SumOfQ1
45 - 64 Years], Sum([Tbl Age].[Q1 > = 65 Years]) AS [SumOfQ1 > = 65
Years], Sum([Tbl Age].[Q1 Other]) AS [SumOfQ1 Other], Sum([Tbl Age].
[Q1 No Response]) AS [SumOfQ1 No Response], Sum([Tbl Age].[Q2 18 - 24
Years]) AS [SumOfQ2 18 - 24 Years], Sum([Tbl Age].[Q2 25 - 44 Years])
AS [SumOfQ2 25 - 44 Years], Sum([Tbl Age].[Q2 45 - 64 Years]) AS
[SumOfQ2 45 - 64 Years], Sum([Tbl Age].[Q2 > = 65 Years]) AS [SumOfQ2
- 24 Years]) AS [SumOfQ3 18 - 24 Years], Sum([Tbl Age].[Q3 25 - 44
Years]) AS [SumOfQ3 25 - 44 Years], Sum([Tbl Age].[Q3 45 - 64 Years])
AS [SumOfQ3 45 - 64 Years], Sum([Tbl Age].[Q3 > = 65 Years]) AS
[SumOfQ3 > = 65 Years], Sum([Tbl Age].[Q3 Other]) AS [SumOfQ3 Other],
Sum([Tbl Age].[Q3 No Response]) AS [SumOfQ3 No Response], Sum([Tbl
Age].[Q4 18 - 24 Years]) AS [SumOfQ4 18 - 24 Years], Sum([Tbl Age].[Q4
25 - 44 Years]) AS [SumOfQ4 25 - 44 Years], Sum([Tbl Age].[Q4 45 - 64
Years]) AS [SumOfQ4 45 - 64 Years], Sum([Tbl Age].[Q4 > = 65 Years])
AS [SumOfQ4 > = 65 Years], Sum([Tbl Age].[Q4 Other]) AS [SumOfQ4
Other], Sum([Tbl Age].[Q4 No Response]) AS [SumOfQ4 No Response], Sum
([Tbl Employment].[Q1 Employed]) AS [SumOfQ1 Employed], Sum([Tbl
Employment].[Q1 Out of Work]) AS [SumOfQ1 Out of Work], Sum([Tbl
Employment].[Q1 Homemaker/Student]) AS [SumOfQ1 Homemaker/Student], Sum
([Tbl Employment].[Q1 Retired/Unable to Work]) AS [SumOfQ1 Retired/
Unable to Work], Sum([Tbl Employment].[Q1 Other]) AS [SumOfQ1 Other2],
Sum([Tbl Employment].[Q1 No Response]) AS [SumOfQ1 No Response2], Sum
([Tbl Employment].[Q2 Employed]) AS [SumOfQ2 Employed], Sum([Tbl
Employment].[Q2 Out of Work]) AS [SumOfQ2 Out of Work], Sum([Tbl
Employment].[Q2 Homemaker/Student]) AS [SumOfQ2 Homemaker/Student], Sum
([Tbl Employment].[Q2 Retired/Unable to Work]) AS [SumOfQ2 Retired/
Unable to Work], Sum([Tbl Employment].[Q2 Other]) AS [SumOfQ2 Other2],
Sum([Tbl Employment].[Q2 No Response]) AS [SumOfQ2 No Response2], Sum
([Tbl Employment].[Q3 Employed]) AS [SumOfQ3 Employed], Sum([Tbl
Employment].[Q3 Out of Work]) AS [SumOfQ3 Out of Work], Sum([Tbl
Employment].[Q3 Homemaker/Student]) AS [SumOfQ3 Homemaker/Student], Sum
([Tbl Employment].[Q3 Retired/Unable to Work]) AS [SumOfQ3 Retired/
Unable to Work], Sum([Tbl Employment].[Q3 Other]) AS [SumOfQ3 Other2],
Sum([Tbl Employment].[Q3 No Response]) AS [SumOfQ3 No Response2], Sum
([Tbl Employment].[Q4 Employed]) AS [SumOfQ4 Employed], Sum([Tbl
Employment].[Q4 Out of Work]) AS [SumOfQ4 Out of Work], Sum([Tbl
Employment].[Q4 Homemaker/Student]) AS [SumOfQ4 Homemaker/Student], Sum
([Tbl Employment].[Q4 Retired/Unable to Work]) AS [SumOfQ4 Retired/
Unable to Work], Sum([Tbl Employment].[Q4 Other]) AS [SumOfQ4 Other2],
Sum([Tbl Employment].[Q4 No Response]) AS [SumOfQ4 No Response2], Sum
([Tbl Education].[Q1 < = High School]) AS [SumOfQ1 < = High School],
Sum([Tbl Education].[Q1 High School Graduate]) AS [SumOfQ1 High School
Graduate], Sum([Tbl Education].[Q1 Some College/Trade/Vocational
School]) AS [SumOfQ1 Some College/Trade/Vocational School], Sum([Tbl
Education].[Q1 Trade or Vocational School Graduate]) AS [SumOfQ1 Trade
or Vocational School Graduate], Sum([Tbl Education].[Q1 College
Graduate]) AS [SumOfQ1 College Graduate], Sum([Tbl Education].[Q1
Graduate Degrees]) AS [SumOfQ1 Graduate Degrees], Sum([Tbl Education].
[Q1 Other]) AS [SumOfQ1 Other3], Sum([Tbl Education].[Q1 No Response])
AS [SumOfQ1 No Response3], Sum([Tbl Education].[Q2 < = High School])
AS [SumOfQ2 < = High School], Sum([Tbl Education].[Q2 High School
Graduate]) AS [SumOfQ2 High School Graduate], Sum([Tbl Education].[Q2
Some College/Trade/Vocational School]) AS [SumOfQ2 Some College/Trade/
Vocational School], Sum([Tbl Education].[Q2 Trade or Vocational School
Graduate]) AS [SumOfQ2 Trade or Vocational School Graduate], Sum([Tbl
Education].[Q2 College Graduate]) AS [SumOfQ2 College Graduate], Sum
([Tbl Education].[Q2 Graduate Degrees]) AS [SumOfQ2 Graduate Degrees],
Sum([Tbl Education].[Q2 Other]) AS [SumOfQ2 Other3], Sum([Tbl
Education].[Q2 No Response]) AS [SumOfQ2 No Response3], Sum([Tbl
Education].[Q3 < = High School]) AS [SumOfQ3 < = High School], Sum
([Tbl Education].[Q3 High School Graduate]) AS [SumOfQ3 High School
Graduate], Sum([Tbl Education].[Q3 Some College/Trade/Vocational
School]) AS [SumOfQ3 Some College/Trade/Vocational School], Sum([Tbl
Education].[Q3 Trade or Vocational School Graduate]) AS [SumOfQ3 Trade
or Vocational School Graduate], Sum([Tbl Education].[Q3 College
Graduate]) AS [SumOfQ3 College Graduate], Sum([Tbl Education].[Q3
Graduate Degrees]) AS [SumOfQ3 Graduate Degrees], Sum([Tbl Education].
[Q3 Other]) AS [SumOfQ3 Other3], Sum([Tbl Education].[Q3 No Response])
AS [SumOfQ3 No Response3], Sum([Tbl Education].[Q4 < = High School])
AS [SumOfQ4 < = High School], Sum([Tbl Education].[Q4 High School
Graduate]) AS [SumOfQ4 High School Graduate], Sum([Tbl Education].[Q4
Some College/Trade/Vocational School]) AS [SumOfQ4 Some College/Trade/
Vocational School], Sum([Tbl Education].[Q4 Trade or Vocational School
Graduate]) AS [SumOfQ4 Trade or Vocational School Graduate], Sum([Tbl
Education].[Q4 College Graduate]) AS [SumOfQ4 College Graduate], Sum
([Tbl Education].[Q4 Graduate Degrees]) AS [SumOfQ4 Graduate Degrees],
Sum([Tbl Education].[Q4 Other]) AS [SumOfQ4 Other3], Sum([Tbl
Education].[Q4 No Response]) AS [SumOfQ4 No Response3], Sum([Tbl
Income].[Q1 < = $15,000]) AS [SumOfQ1 < = $15,000], Sum([Tbl Income].
[Q1 $15,000 - $35,000]) AS [SumOfQ1 $15,000 - $35,000], Sum([Tbl
Income].[Q1 $35,000 - $50,000]) AS [SumOfQ1 $35,000 - $50,000], Sum
([Tbl Income].[Q1 $50,000 - $75,000]) AS [SumOfQ1 $50,000 - $75,000],
Sum([Tbl Income].[Q1 > = $75,000]) AS [SumOfQ1 > = $75,000], Sum([Tbl
Income].[Q1 Other]) AS [SumOfQ1 Other4], Sum([Tbl Income].[Q1 No
Response]) AS [SumOfQ1 No Response4], Sum([Tbl Income].[Q2 < =
$15,000]) AS [SumOfQ2 < = $15,000], Sum([Tbl Income].[Q2 $15,000 -
$35,000]) AS [SumOfQ2 $15,000 - $35,000], Sum([Tbl Income].[Q2 $35,000
- $50,000]) AS [SumOfQ2 $35,000 - $50,000], Sum([Tbl Income].[Q2
$50,000 - $75,000]) AS [SumOfQ2 $50,000 - $75,000], Sum([Tbl Income].
[Q2 > = $75,000]) AS [SumOfQ2 > = $75,000], Sum([Tbl Income].[Q2
Other]) AS [SumOfQ2 Other4], Sum([Tbl Income].[Q2 No Response]) AS
[SumOfQ2 No Response4], Sum([Tbl Income].[Q3 < = $15,000]) AS [SumOfQ3
< = $15,000], Sum([Tbl Income].[Q3 $15,000 - $35,000]) AS [SumOfQ3
$15,000 - $35,000], Sum([Tbl Income].[Q3 $35,000 - $50,000]) AS
[SumOfQ3 $35,000 - $50,000], Sum([Tbl Income].[Q3 $50,000 - $75,000])
AS [SumOfQ3 $50,000 - $75,000], Sum([Tbl Income].[Q3 > = $75,000]) AS
[SumOfQ3 > = $75,000], Sum([Tbl Income].[Q3 Other]) AS [SumOfQ3
Other4], Sum([Tbl Income].[Q3 No Response]) AS [SumOfQ3 No Response4],
Sum([Tbl Income].[Q4 < = $15,000]) AS [SumOfQ4 < = $15,000], Sum([Tbl
Income].[Q4 $15,000 - $35,000]) AS [SumOfQ4 $15,000 - $35,000], Sum
([Tbl Income].[Q4 $35,000 - $50,000]) AS [SumOfQ4 $35,000 - $50,000],
Sum([Tbl Income].[Q4 $50,000 - $75,000]) AS [SumOfQ4 $50,000 -
$75,000], Sum([Tbl Income].[Q4 > = $75,000]) AS [SumOfQ4 > = $75,000],
Sum([Tbl Income].[Q4 Other]) AS [SumOfQ4 Other4], Sum([Tbl Income].[Q4
No Response]) AS [SumOfQ4 No Response4], Sum([Tbl Race].[Q1 Asian]) AS
[SumOfQ1 Asian], Sum([Tbl Race].[Q1 American Indian/Alaska Native]) AS
[SumOfQ1 American Indian/Alaska Native], Sum([Tbl Race].[Q1 Black/
African American]) AS [SumOfQ1 Black/African American], Sum([Tbl Race].
[Q1 Native Hawaiian/Pacific Islander]) AS [SumOfQ1 Native Hawaiian/
Pacific Islander], Sum([Tbl Race].[Q1 White]) AS [SumOfQ1 White], Sum
([Tbl Race].[Q1 Other]) AS [SumOfQ1 Other1], Sum([Tbl Race].[Q1 No
Response]) AS [SumOfQ1 No Response1], Sum([Tbl Race].[Q2 Asian]) AS
[SumOfQ2 Asian], Sum([Tbl Race].[Q2 American Indian/Alaska Native]) AS
[SumOfQ2 American Indian/Alaska Native], Sum([Tbl Race].[Q2 Black/
African American]) AS [SumOfQ2 Black/African American], Sum([Tbl Race].
[Q2 Native Hawaiian/Pacific Islander]) AS [SumOfQ2 Native Hawaiian/
Pacific Islander], Sum([Tbl Race].[Q2 White]) AS [SumOfQ2 White], Sum
([Tbl Race].[Q2 Other]) AS [SumOfQ2 Other1], Sum([Tbl Race].[Q2 No
Response]) AS [SumOfQ2 No Response1], Sum([Tbl Race].[Q3 Asian]) AS
[SumOfQ3 Asian], Sum([Tbl Race].[Q3 American Indian/Alaska Native]) AS
[SumOfQ3 American Indian/Alaska Native], Sum([Tbl Race].[Q3 Black/
African American]) AS [SumOfQ3 Black/African American], Sum([Tbl Race].
[Q3 Native Hawaiian/Pacific Islander]) AS [SumOfQ3 Native Hawaiian/
Pacific Islander], Sum([Tbl Race].[Q3 White]) AS [SumOfQ3 White], Sum
([Tbl Race].[Q3 Other]) AS [SumOfQ3 Other1], Sum([Tbl Race].[Q3 No
Response]) AS [SumOfQ3 No Response1], Sum([Tbl Race].[Q4 Asian]) AS
[SumOfQ4 Asian], Sum([Tbl Race].[Q4 American Indian/Alaska Native]) AS
[SumOfQ4 American Indian/Alaska Native], Sum([Tbl Race].[Q4 Black/
African American]) AS [SumOfQ4 Black/African American], Sum([Tbl Race].
[Q4 Native Hawaiian/Pacific Islander]) AS [SumOfQ4 Native Hawaiian/
Pacific Islander], Sum([Tbl Race].[Q4 White]) AS [SumOfQ4 White], Sum
([Tbl Race].[Q4 Other]) AS [SumOfQ4 Other1], Sum([Tbl Race].[Q4 No
Response]) AS [SumOfQ4 No Response1], Sum([Tbl Ethnicity].[Q1 Hispanic/
Latino]) AS [SumOfQ1 Hispanic/Latino], Sum([Tbl Ethnicity].[Q1 Not
Hispanic/Latino]) AS [SumOfQ1 Not Hispanic/Latino], Sum([Tbl
Ethnicity].[Q1 Other]) AS [SumOfQ1 Other5], Sum([Tbl Ethnicity].[Q1 No
Response]) AS [SumOfQ1 No Response5], Sum([Tbl Ethnicity].[Q2 Hispanic/
Latino]) AS [SumOfQ2 Hispanic/Latino], Sum([Tbl Ethnicity].[Q2 Not
Hispanic/Latino]) AS [SumOfQ2 Not Hispanic/Latino], Sum([Tbl
Ethnicity].[Q2 Other]) AS [SumOfQ2 Other5], Sum([Tbl Ethnicity].[Q2 No
Response]) AS [SumOfQ2 No Response5], Sum([Tbl Ethnicity].[Q3 Hispanic/
Latino]) AS [SumOfQ3 Hispanic/Latino], Sum([Tbl Ethnicity].[Q3 Not
Hispanic/Latino]) AS [SumOfQ3 Not Hispanic/Latino], Sum([Tbl
Ethnicity].[Q3 Other]) AS [SumOfQ3 Other5], Sum([Tbl Ethnicity].[Q3 No
Response]) AS [SumOfQ3 No Response5], Sum([Tbl Ethnicity].[Q4 Hispanic/
Latino]) AS [SumOfQ4 Hispanic/Latino], Sum([Tbl Ethnicity].[Q4 Not
Hispanic/Latino]) AS [SumOfQ4 Not Hispanic/Latino], Sum([Tbl
Ethnicity].[Q4 Other]) AS [SumOfQ4 Other5], Sum([Tbl Ethnicity].[Q4 No
Response]) AS [SumOfQ4 No Response5], Sum([Tbl Life Smart for Women].
[Q1 Completing Series]) AS [SumOfQ1 Completing Series], Sum([Tbl Life
Smart for Women].[Q1 Completing Part 1 Pre/Post Test]) AS [SumOfQ1
Completing Part 1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q1
Improvement on Part 1 Pre/Post Test]) AS [SumOfQ1 Improvement on Part
1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q1 Completing Part 2
Pre/Post Test]) AS [SumOfQ1 Completing Part 2 Pre/Post Test], Sum([Tbl
Life Smart for Women].[Q1 Improvement on Part 2 Pre/Post Test]) AS
[SumOfQ1 Improvement on Part 2 Pre/Post Test], Sum([Tbl Life Smart for
Women].[Q1 Participants Followed Up With]) AS [SumOfQ1 Participants
Followed Up With], Sum([Tbl Life Smart for Women].[Q1 Maintaining
Improved Knowledge]) AS [SumOfQ1 Maintaining Improved Knowledge], Sum
([Tbl Life Smart for Women].[Q1 Maintaining Behavior Change]) AS
[SumOfQ1 Maintaining Behavior Change], Sum([Tbl Life Smart for Women].
[Q2 Completing Series]) AS [SumOfQ2 Completing Series], Sum([Tbl Life
Smart for Women].[Q2 Completing Part 1 Pre/Post Test]) AS [SumOfQ2
Completing Part 1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q2
Improvement on Part 1 Pre/Post Test]) AS [SumOfQ2 Improvement on Part
1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q2 Completing Part 2
Pre/Post Test]) AS [SumOfQ2 Completing Part 2 Pre/Post Test], Sum([Tbl
Life Smart for Women].[Q2 Improvement on Part 2 Pre/Post Test]) AS
[SumOfQ2 Improvement on Part 2 Pre/Post Test], Sum([Tbl Life Smart for
Women].[Q2 Participants Followed Up With]) AS [SumOfQ2 Participants
Followed Up With], Sum([Tbl Life Smart for Women].[Q2 Maintaining
Improved Knowledge]) AS [SumOfQ2 Maintaining Improved Knowledge], Sum
([Tbl Life Smart for Women].[Q2 Maintaining Behavior Change]) AS
[SumOfQ2 Maintaining Behavior Change], Sum([Tbl Life Smart for Women].
[Q3 Completing Series]) AS [SumOfQ3 Completing Series], Sum([Tbl Life
Smart for Women].[Q3 Completing Part 1 Pre/Post Test]) AS [SumOfQ3
Completing Part 1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q3
Improvement on Part 1 Pre/Post Test]) AS [SumOfQ3 Improvement on Part
1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q3 Completing Part 2
Pre/Post Test]) AS [SumOfQ3 Completing Part 2 Pre/Post Test], Sum([Tbl
Life Smart for Women].[Q3 Improvement on Part 2 Pre/Post Test]) AS
[SumOfQ3 Improvement on Part 2 Pre/Post Test], Sum([Tbl Life Smart for
Women].[Q3 Participants Followed Up With]) AS [SumOfQ3 Participants
Followed Up With], Sum([Tbl Life Smart for Women].[Q3 Maintaining
Improved Knowledge]) AS [SumOfQ3 Maintaining Improved Knowledge], Sum
([Tbl Life Smart for Women].[Q3 Maintaining Behavior Change]) AS
[SumOfQ3 Maintaining Behavior Change], Sum([Tbl Life Smart for Women].
[Q4 Completing Series]) AS [SumOfQ4 Completing Series], Sum([Tbl Life
Smart for Women].[Q4 Completing Part 1 Pre/Post Test]) AS [SumOfQ4
Completing Part 1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q4
Improvement on Part 1 Pre/Post Test]) AS [SumOfQ4 Improvement on Part
1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q4 Completing Part 2
Pre/Post Test]) AS [SumOfQ4 Completing Part 2 Pre/Post Test], Sum([Tbl
Life Smart for Women].[Q4 Improvement on Part 2 Pre/Post Test]) AS
[SumOfQ4 Improvement on Part 2 Pre/Post Test], Sum([Tbl Life Smart for
Women].[Q4 Participants Followed Up With]) AS [SumOfQ4 Participants
Followed Up With], Sum([Tbl Life Smart for Women].[Q4 Maintaining
Improved Knowledge]) AS [SumOfQ4 Maintaining Improved Knowledge], Sum
([Tbl Life Smart for Women].[Q4 Maintaining Behavior Change]) AS
[SumOfQ4 Maintaining Behavior Change]
FROM (((((([Tbl Main ID] LEFT JOIN [Tbl Employment] ON [Tbl Main
ID].ID = [Tbl Employment].ID) LEFT JOIN [Tbl Education] ON [Tbl Main
ID].ID = [Tbl Education].ID) LEFT JOIN [Tbl Income] ON [Tbl Main
ID].ID = [Tbl Income].ID) LEFT JOIN [Tbl Age] ON [Tbl Main ID].ID =
[Tbl Age].ID) INNER JOIN [Tbl Ethnicity] ON [Tbl Main ID].ID = [Tbl
Ethnicity].ID) LEFT JOIN [Tbl Life Smart for Women] ON [Tbl Main
ID].ID = [Tbl Life Smart for Women].ID) LEFT JOIN [Tbl Race] ON [Tbl
Main ID].ID = [Tbl Race].ID
GROUP BY [Tbl Main ID].[Program Name]
HAVING ((([Tbl Main ID].[Program Name])="Life Smart for Women"));
Any suggestions you have will be gladly welcomed!
Best,
John
record so I must modify or create another query to resolve this.
How do I fix this?
The information for the queries and reports are entered on subforms.
Here is my query behind the report Life Smart For Women:
SELECT [Tbl Main ID].[Program Name], Sum([Tbl Age].[Q1 18 - 24 Years])
AS [SumOfQ1 18 - 24 Years], Sum([Tbl Age].[Q1 25 - 44 Years]) AS
[SumOfQ1 25 - 44 Years], Sum([Tbl Age].[Q1 45 - 64 Years]) AS [SumOfQ1
45 - 64 Years], Sum([Tbl Age].[Q1 > = 65 Years]) AS [SumOfQ1 > = 65
Years], Sum([Tbl Age].[Q1 Other]) AS [SumOfQ1 Other], Sum([Tbl Age].
[Q1 No Response]) AS [SumOfQ1 No Response], Sum([Tbl Age].[Q2 18 - 24
Years]) AS [SumOfQ2 18 - 24 Years], Sum([Tbl Age].[Q2 25 - 44 Years])
AS [SumOfQ2 25 - 44 Years], Sum([Tbl Age].[Q2 45 - 64 Years]) AS
[SumOfQ2 45 - 64 Years], Sum([Tbl Age].[Q2 > = 65 Years]) AS [SumOfQ2
Age].[Q2 No Response]) AS [SumOfQ2 No Response], Sum([Tbl Age].[Q3 18
- 24 Years]) AS [SumOfQ3 18 - 24 Years], Sum([Tbl Age].[Q3 25 - 44
Years]) AS [SumOfQ3 25 - 44 Years], Sum([Tbl Age].[Q3 45 - 64 Years])
AS [SumOfQ3 45 - 64 Years], Sum([Tbl Age].[Q3 > = 65 Years]) AS
[SumOfQ3 > = 65 Years], Sum([Tbl Age].[Q3 Other]) AS [SumOfQ3 Other],
Sum([Tbl Age].[Q3 No Response]) AS [SumOfQ3 No Response], Sum([Tbl
Age].[Q4 18 - 24 Years]) AS [SumOfQ4 18 - 24 Years], Sum([Tbl Age].[Q4
25 - 44 Years]) AS [SumOfQ4 25 - 44 Years], Sum([Tbl Age].[Q4 45 - 64
Years]) AS [SumOfQ4 45 - 64 Years], Sum([Tbl Age].[Q4 > = 65 Years])
AS [SumOfQ4 > = 65 Years], Sum([Tbl Age].[Q4 Other]) AS [SumOfQ4
Other], Sum([Tbl Age].[Q4 No Response]) AS [SumOfQ4 No Response], Sum
([Tbl Employment].[Q1 Employed]) AS [SumOfQ1 Employed], Sum([Tbl
Employment].[Q1 Out of Work]) AS [SumOfQ1 Out of Work], Sum([Tbl
Employment].[Q1 Homemaker/Student]) AS [SumOfQ1 Homemaker/Student], Sum
([Tbl Employment].[Q1 Retired/Unable to Work]) AS [SumOfQ1 Retired/
Unable to Work], Sum([Tbl Employment].[Q1 Other]) AS [SumOfQ1 Other2],
Sum([Tbl Employment].[Q1 No Response]) AS [SumOfQ1 No Response2], Sum
([Tbl Employment].[Q2 Employed]) AS [SumOfQ2 Employed], Sum([Tbl
Employment].[Q2 Out of Work]) AS [SumOfQ2 Out of Work], Sum([Tbl
Employment].[Q2 Homemaker/Student]) AS [SumOfQ2 Homemaker/Student], Sum
([Tbl Employment].[Q2 Retired/Unable to Work]) AS [SumOfQ2 Retired/
Unable to Work], Sum([Tbl Employment].[Q2 Other]) AS [SumOfQ2 Other2],
Sum([Tbl Employment].[Q2 No Response]) AS [SumOfQ2 No Response2], Sum
([Tbl Employment].[Q3 Employed]) AS [SumOfQ3 Employed], Sum([Tbl
Employment].[Q3 Out of Work]) AS [SumOfQ3 Out of Work], Sum([Tbl
Employment].[Q3 Homemaker/Student]) AS [SumOfQ3 Homemaker/Student], Sum
([Tbl Employment].[Q3 Retired/Unable to Work]) AS [SumOfQ3 Retired/
Unable to Work], Sum([Tbl Employment].[Q3 Other]) AS [SumOfQ3 Other2],
Sum([Tbl Employment].[Q3 No Response]) AS [SumOfQ3 No Response2], Sum
([Tbl Employment].[Q4 Employed]) AS [SumOfQ4 Employed], Sum([Tbl
Employment].[Q4 Out of Work]) AS [SumOfQ4 Out of Work], Sum([Tbl
Employment].[Q4 Homemaker/Student]) AS [SumOfQ4 Homemaker/Student], Sum
([Tbl Employment].[Q4 Retired/Unable to Work]) AS [SumOfQ4 Retired/
Unable to Work], Sum([Tbl Employment].[Q4 Other]) AS [SumOfQ4 Other2],
Sum([Tbl Employment].[Q4 No Response]) AS [SumOfQ4 No Response2], Sum
([Tbl Education].[Q1 < = High School]) AS [SumOfQ1 < = High School],
Sum([Tbl Education].[Q1 High School Graduate]) AS [SumOfQ1 High School
Graduate], Sum([Tbl Education].[Q1 Some College/Trade/Vocational
School]) AS [SumOfQ1 Some College/Trade/Vocational School], Sum([Tbl
Education].[Q1 Trade or Vocational School Graduate]) AS [SumOfQ1 Trade
or Vocational School Graduate], Sum([Tbl Education].[Q1 College
Graduate]) AS [SumOfQ1 College Graduate], Sum([Tbl Education].[Q1
Graduate Degrees]) AS [SumOfQ1 Graduate Degrees], Sum([Tbl Education].
[Q1 Other]) AS [SumOfQ1 Other3], Sum([Tbl Education].[Q1 No Response])
AS [SumOfQ1 No Response3], Sum([Tbl Education].[Q2 < = High School])
AS [SumOfQ2 < = High School], Sum([Tbl Education].[Q2 High School
Graduate]) AS [SumOfQ2 High School Graduate], Sum([Tbl Education].[Q2
Some College/Trade/Vocational School]) AS [SumOfQ2 Some College/Trade/
Vocational School], Sum([Tbl Education].[Q2 Trade or Vocational School
Graduate]) AS [SumOfQ2 Trade or Vocational School Graduate], Sum([Tbl
Education].[Q2 College Graduate]) AS [SumOfQ2 College Graduate], Sum
([Tbl Education].[Q2 Graduate Degrees]) AS [SumOfQ2 Graduate Degrees],
Sum([Tbl Education].[Q2 Other]) AS [SumOfQ2 Other3], Sum([Tbl
Education].[Q2 No Response]) AS [SumOfQ2 No Response3], Sum([Tbl
Education].[Q3 < = High School]) AS [SumOfQ3 < = High School], Sum
([Tbl Education].[Q3 High School Graduate]) AS [SumOfQ3 High School
Graduate], Sum([Tbl Education].[Q3 Some College/Trade/Vocational
School]) AS [SumOfQ3 Some College/Trade/Vocational School], Sum([Tbl
Education].[Q3 Trade or Vocational School Graduate]) AS [SumOfQ3 Trade
or Vocational School Graduate], Sum([Tbl Education].[Q3 College
Graduate]) AS [SumOfQ3 College Graduate], Sum([Tbl Education].[Q3
Graduate Degrees]) AS [SumOfQ3 Graduate Degrees], Sum([Tbl Education].
[Q3 Other]) AS [SumOfQ3 Other3], Sum([Tbl Education].[Q3 No Response])
AS [SumOfQ3 No Response3], Sum([Tbl Education].[Q4 < = High School])
AS [SumOfQ4 < = High School], Sum([Tbl Education].[Q4 High School
Graduate]) AS [SumOfQ4 High School Graduate], Sum([Tbl Education].[Q4
Some College/Trade/Vocational School]) AS [SumOfQ4 Some College/Trade/
Vocational School], Sum([Tbl Education].[Q4 Trade or Vocational School
Graduate]) AS [SumOfQ4 Trade or Vocational School Graduate], Sum([Tbl
Education].[Q4 College Graduate]) AS [SumOfQ4 College Graduate], Sum
([Tbl Education].[Q4 Graduate Degrees]) AS [SumOfQ4 Graduate Degrees],
Sum([Tbl Education].[Q4 Other]) AS [SumOfQ4 Other3], Sum([Tbl
Education].[Q4 No Response]) AS [SumOfQ4 No Response3], Sum([Tbl
Income].[Q1 < = $15,000]) AS [SumOfQ1 < = $15,000], Sum([Tbl Income].
[Q1 $15,000 - $35,000]) AS [SumOfQ1 $15,000 - $35,000], Sum([Tbl
Income].[Q1 $35,000 - $50,000]) AS [SumOfQ1 $35,000 - $50,000], Sum
([Tbl Income].[Q1 $50,000 - $75,000]) AS [SumOfQ1 $50,000 - $75,000],
Sum([Tbl Income].[Q1 > = $75,000]) AS [SumOfQ1 > = $75,000], Sum([Tbl
Income].[Q1 Other]) AS [SumOfQ1 Other4], Sum([Tbl Income].[Q1 No
Response]) AS [SumOfQ1 No Response4], Sum([Tbl Income].[Q2 < =
$15,000]) AS [SumOfQ2 < = $15,000], Sum([Tbl Income].[Q2 $15,000 -
$35,000]) AS [SumOfQ2 $15,000 - $35,000], Sum([Tbl Income].[Q2 $35,000
- $50,000]) AS [SumOfQ2 $35,000 - $50,000], Sum([Tbl Income].[Q2
$50,000 - $75,000]) AS [SumOfQ2 $50,000 - $75,000], Sum([Tbl Income].
[Q2 > = $75,000]) AS [SumOfQ2 > = $75,000], Sum([Tbl Income].[Q2
Other]) AS [SumOfQ2 Other4], Sum([Tbl Income].[Q2 No Response]) AS
[SumOfQ2 No Response4], Sum([Tbl Income].[Q3 < = $15,000]) AS [SumOfQ3
< = $15,000], Sum([Tbl Income].[Q3 $15,000 - $35,000]) AS [SumOfQ3
$15,000 - $35,000], Sum([Tbl Income].[Q3 $35,000 - $50,000]) AS
[SumOfQ3 $35,000 - $50,000], Sum([Tbl Income].[Q3 $50,000 - $75,000])
AS [SumOfQ3 $50,000 - $75,000], Sum([Tbl Income].[Q3 > = $75,000]) AS
[SumOfQ3 > = $75,000], Sum([Tbl Income].[Q3 Other]) AS [SumOfQ3
Other4], Sum([Tbl Income].[Q3 No Response]) AS [SumOfQ3 No Response4],
Sum([Tbl Income].[Q4 < = $15,000]) AS [SumOfQ4 < = $15,000], Sum([Tbl
Income].[Q4 $15,000 - $35,000]) AS [SumOfQ4 $15,000 - $35,000], Sum
([Tbl Income].[Q4 $35,000 - $50,000]) AS [SumOfQ4 $35,000 - $50,000],
Sum([Tbl Income].[Q4 $50,000 - $75,000]) AS [SumOfQ4 $50,000 -
$75,000], Sum([Tbl Income].[Q4 > = $75,000]) AS [SumOfQ4 > = $75,000],
Sum([Tbl Income].[Q4 Other]) AS [SumOfQ4 Other4], Sum([Tbl Income].[Q4
No Response]) AS [SumOfQ4 No Response4], Sum([Tbl Race].[Q1 Asian]) AS
[SumOfQ1 Asian], Sum([Tbl Race].[Q1 American Indian/Alaska Native]) AS
[SumOfQ1 American Indian/Alaska Native], Sum([Tbl Race].[Q1 Black/
African American]) AS [SumOfQ1 Black/African American], Sum([Tbl Race].
[Q1 Native Hawaiian/Pacific Islander]) AS [SumOfQ1 Native Hawaiian/
Pacific Islander], Sum([Tbl Race].[Q1 White]) AS [SumOfQ1 White], Sum
([Tbl Race].[Q1 Other]) AS [SumOfQ1 Other1], Sum([Tbl Race].[Q1 No
Response]) AS [SumOfQ1 No Response1], Sum([Tbl Race].[Q2 Asian]) AS
[SumOfQ2 Asian], Sum([Tbl Race].[Q2 American Indian/Alaska Native]) AS
[SumOfQ2 American Indian/Alaska Native], Sum([Tbl Race].[Q2 Black/
African American]) AS [SumOfQ2 Black/African American], Sum([Tbl Race].
[Q2 Native Hawaiian/Pacific Islander]) AS [SumOfQ2 Native Hawaiian/
Pacific Islander], Sum([Tbl Race].[Q2 White]) AS [SumOfQ2 White], Sum
([Tbl Race].[Q2 Other]) AS [SumOfQ2 Other1], Sum([Tbl Race].[Q2 No
Response]) AS [SumOfQ2 No Response1], Sum([Tbl Race].[Q3 Asian]) AS
[SumOfQ3 Asian], Sum([Tbl Race].[Q3 American Indian/Alaska Native]) AS
[SumOfQ3 American Indian/Alaska Native], Sum([Tbl Race].[Q3 Black/
African American]) AS [SumOfQ3 Black/African American], Sum([Tbl Race].
[Q3 Native Hawaiian/Pacific Islander]) AS [SumOfQ3 Native Hawaiian/
Pacific Islander], Sum([Tbl Race].[Q3 White]) AS [SumOfQ3 White], Sum
([Tbl Race].[Q3 Other]) AS [SumOfQ3 Other1], Sum([Tbl Race].[Q3 No
Response]) AS [SumOfQ3 No Response1], Sum([Tbl Race].[Q4 Asian]) AS
[SumOfQ4 Asian], Sum([Tbl Race].[Q4 American Indian/Alaska Native]) AS
[SumOfQ4 American Indian/Alaska Native], Sum([Tbl Race].[Q4 Black/
African American]) AS [SumOfQ4 Black/African American], Sum([Tbl Race].
[Q4 Native Hawaiian/Pacific Islander]) AS [SumOfQ4 Native Hawaiian/
Pacific Islander], Sum([Tbl Race].[Q4 White]) AS [SumOfQ4 White], Sum
([Tbl Race].[Q4 Other]) AS [SumOfQ4 Other1], Sum([Tbl Race].[Q4 No
Response]) AS [SumOfQ4 No Response1], Sum([Tbl Ethnicity].[Q1 Hispanic/
Latino]) AS [SumOfQ1 Hispanic/Latino], Sum([Tbl Ethnicity].[Q1 Not
Hispanic/Latino]) AS [SumOfQ1 Not Hispanic/Latino], Sum([Tbl
Ethnicity].[Q1 Other]) AS [SumOfQ1 Other5], Sum([Tbl Ethnicity].[Q1 No
Response]) AS [SumOfQ1 No Response5], Sum([Tbl Ethnicity].[Q2 Hispanic/
Latino]) AS [SumOfQ2 Hispanic/Latino], Sum([Tbl Ethnicity].[Q2 Not
Hispanic/Latino]) AS [SumOfQ2 Not Hispanic/Latino], Sum([Tbl
Ethnicity].[Q2 Other]) AS [SumOfQ2 Other5], Sum([Tbl Ethnicity].[Q2 No
Response]) AS [SumOfQ2 No Response5], Sum([Tbl Ethnicity].[Q3 Hispanic/
Latino]) AS [SumOfQ3 Hispanic/Latino], Sum([Tbl Ethnicity].[Q3 Not
Hispanic/Latino]) AS [SumOfQ3 Not Hispanic/Latino], Sum([Tbl
Ethnicity].[Q3 Other]) AS [SumOfQ3 Other5], Sum([Tbl Ethnicity].[Q3 No
Response]) AS [SumOfQ3 No Response5], Sum([Tbl Ethnicity].[Q4 Hispanic/
Latino]) AS [SumOfQ4 Hispanic/Latino], Sum([Tbl Ethnicity].[Q4 Not
Hispanic/Latino]) AS [SumOfQ4 Not Hispanic/Latino], Sum([Tbl
Ethnicity].[Q4 Other]) AS [SumOfQ4 Other5], Sum([Tbl Ethnicity].[Q4 No
Response]) AS [SumOfQ4 No Response5], Sum([Tbl Life Smart for Women].
[Q1 Completing Series]) AS [SumOfQ1 Completing Series], Sum([Tbl Life
Smart for Women].[Q1 Completing Part 1 Pre/Post Test]) AS [SumOfQ1
Completing Part 1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q1
Improvement on Part 1 Pre/Post Test]) AS [SumOfQ1 Improvement on Part
1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q1 Completing Part 2
Pre/Post Test]) AS [SumOfQ1 Completing Part 2 Pre/Post Test], Sum([Tbl
Life Smart for Women].[Q1 Improvement on Part 2 Pre/Post Test]) AS
[SumOfQ1 Improvement on Part 2 Pre/Post Test], Sum([Tbl Life Smart for
Women].[Q1 Participants Followed Up With]) AS [SumOfQ1 Participants
Followed Up With], Sum([Tbl Life Smart for Women].[Q1 Maintaining
Improved Knowledge]) AS [SumOfQ1 Maintaining Improved Knowledge], Sum
([Tbl Life Smart for Women].[Q1 Maintaining Behavior Change]) AS
[SumOfQ1 Maintaining Behavior Change], Sum([Tbl Life Smart for Women].
[Q2 Completing Series]) AS [SumOfQ2 Completing Series], Sum([Tbl Life
Smart for Women].[Q2 Completing Part 1 Pre/Post Test]) AS [SumOfQ2
Completing Part 1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q2
Improvement on Part 1 Pre/Post Test]) AS [SumOfQ2 Improvement on Part
1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q2 Completing Part 2
Pre/Post Test]) AS [SumOfQ2 Completing Part 2 Pre/Post Test], Sum([Tbl
Life Smart for Women].[Q2 Improvement on Part 2 Pre/Post Test]) AS
[SumOfQ2 Improvement on Part 2 Pre/Post Test], Sum([Tbl Life Smart for
Women].[Q2 Participants Followed Up With]) AS [SumOfQ2 Participants
Followed Up With], Sum([Tbl Life Smart for Women].[Q2 Maintaining
Improved Knowledge]) AS [SumOfQ2 Maintaining Improved Knowledge], Sum
([Tbl Life Smart for Women].[Q2 Maintaining Behavior Change]) AS
[SumOfQ2 Maintaining Behavior Change], Sum([Tbl Life Smart for Women].
[Q3 Completing Series]) AS [SumOfQ3 Completing Series], Sum([Tbl Life
Smart for Women].[Q3 Completing Part 1 Pre/Post Test]) AS [SumOfQ3
Completing Part 1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q3
Improvement on Part 1 Pre/Post Test]) AS [SumOfQ3 Improvement on Part
1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q3 Completing Part 2
Pre/Post Test]) AS [SumOfQ3 Completing Part 2 Pre/Post Test], Sum([Tbl
Life Smart for Women].[Q3 Improvement on Part 2 Pre/Post Test]) AS
[SumOfQ3 Improvement on Part 2 Pre/Post Test], Sum([Tbl Life Smart for
Women].[Q3 Participants Followed Up With]) AS [SumOfQ3 Participants
Followed Up With], Sum([Tbl Life Smart for Women].[Q3 Maintaining
Improved Knowledge]) AS [SumOfQ3 Maintaining Improved Knowledge], Sum
([Tbl Life Smart for Women].[Q3 Maintaining Behavior Change]) AS
[SumOfQ3 Maintaining Behavior Change], Sum([Tbl Life Smart for Women].
[Q4 Completing Series]) AS [SumOfQ4 Completing Series], Sum([Tbl Life
Smart for Women].[Q4 Completing Part 1 Pre/Post Test]) AS [SumOfQ4
Completing Part 1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q4
Improvement on Part 1 Pre/Post Test]) AS [SumOfQ4 Improvement on Part
1 Pre/Post Test], Sum([Tbl Life Smart for Women].[Q4 Completing Part 2
Pre/Post Test]) AS [SumOfQ4 Completing Part 2 Pre/Post Test], Sum([Tbl
Life Smart for Women].[Q4 Improvement on Part 2 Pre/Post Test]) AS
[SumOfQ4 Improvement on Part 2 Pre/Post Test], Sum([Tbl Life Smart for
Women].[Q4 Participants Followed Up With]) AS [SumOfQ4 Participants
Followed Up With], Sum([Tbl Life Smart for Women].[Q4 Maintaining
Improved Knowledge]) AS [SumOfQ4 Maintaining Improved Knowledge], Sum
([Tbl Life Smart for Women].[Q4 Maintaining Behavior Change]) AS
[SumOfQ4 Maintaining Behavior Change]
FROM (((((([Tbl Main ID] LEFT JOIN [Tbl Employment] ON [Tbl Main
ID].ID = [Tbl Employment].ID) LEFT JOIN [Tbl Education] ON [Tbl Main
ID].ID = [Tbl Education].ID) LEFT JOIN [Tbl Income] ON [Tbl Main
ID].ID = [Tbl Income].ID) LEFT JOIN [Tbl Age] ON [Tbl Main ID].ID =
[Tbl Age].ID) INNER JOIN [Tbl Ethnicity] ON [Tbl Main ID].ID = [Tbl
Ethnicity].ID) LEFT JOIN [Tbl Life Smart for Women] ON [Tbl Main
ID].ID = [Tbl Life Smart for Women].ID) LEFT JOIN [Tbl Race] ON [Tbl
Main ID].ID = [Tbl Race].ID
GROUP BY [Tbl Main ID].[Program Name]
HAVING ((([Tbl Main ID].[Program Name])="Life Smart for Women"));
Any suggestions you have will be gladly welcomed!
Best,
John