C
CEV
I am not sure how to get the numbers I am looking for. I have a query that
shows all the records I need totals for. The numbers I need on a report are
the total number of records entered for each OutcomeNumber. Then I need the
total number of "Yes" and "No" for each OutcomeNumber in the field Outcome
and also in the field OutcomeSupports. Finally I need to show the percentage
of Yes's and No's for each. I have listed my query below and would greatly
appreciate help with this as I have never worked with calculations in Access
before.
SELECT tblOutcomes.DateofPlan, tblOutcomes.OutcomeNumber,
tblOutcomes.Outcome, tblOutcomes.OutcomeSupports
FROM Individuals INNER JOIN tblOutcomes ON Individuals.[Social Security
Number] = tblOutcomes.SSAN
WHERE (((tblOutcomes.DateofPlan) Between
[Forms]![frmIndOutcomesReport]![cboBeginDate] And
DateAdd("s",86399,[Forms]![frmIndOutcomesReport]![cboEndDate])) AND
((tblOutcomes.OutcomeNumber)="O01 - People are connected to natural support
networks." Or (tblOutcomes.OutcomeNumber)="O02 - People have intimate
relationships." Or (tblOutcomes.OutcomeNumber)="O03 - People are safe." Or
(tblOutcomes.OutcomeNumber)="O04 - People have the best possible health." Or
(tblOutcomes.OutcomeNumber)="O05 - People exercise rights." Or
(tblOutcomes.OutcomeNumber)="O06 - People are treated fairly." Or
(tblOutcomes.OutcomeNumber)="O07 - People are free from abuse and neglect."
Or (tblOutcomes.OutcomeNumber)="O08 - People experience continuity and
security." Or (tblOutcomes.OutcomeNumber)="O09 - People decide when to share
personal information." Or (tblOutcomes.OutcomeNumber)="O10 - People are
respected."));
Thank You,
Chad
shows all the records I need totals for. The numbers I need on a report are
the total number of records entered for each OutcomeNumber. Then I need the
total number of "Yes" and "No" for each OutcomeNumber in the field Outcome
and also in the field OutcomeSupports. Finally I need to show the percentage
of Yes's and No's for each. I have listed my query below and would greatly
appreciate help with this as I have never worked with calculations in Access
before.
SELECT tblOutcomes.DateofPlan, tblOutcomes.OutcomeNumber,
tblOutcomes.Outcome, tblOutcomes.OutcomeSupports
FROM Individuals INNER JOIN tblOutcomes ON Individuals.[Social Security
Number] = tblOutcomes.SSAN
WHERE (((tblOutcomes.DateofPlan) Between
[Forms]![frmIndOutcomesReport]![cboBeginDate] And
DateAdd("s",86399,[Forms]![frmIndOutcomesReport]![cboEndDate])) AND
((tblOutcomes.OutcomeNumber)="O01 - People are connected to natural support
networks." Or (tblOutcomes.OutcomeNumber)="O02 - People have intimate
relationships." Or (tblOutcomes.OutcomeNumber)="O03 - People are safe." Or
(tblOutcomes.OutcomeNumber)="O04 - People have the best possible health." Or
(tblOutcomes.OutcomeNumber)="O05 - People exercise rights." Or
(tblOutcomes.OutcomeNumber)="O06 - People are treated fairly." Or
(tblOutcomes.OutcomeNumber)="O07 - People are free from abuse and neglect."
Or (tblOutcomes.OutcomeNumber)="O08 - People experience continuity and
security." Or (tblOutcomes.OutcomeNumber)="O09 - People decide when to share
personal information." Or (tblOutcomes.OutcomeNumber)="O10 - People are
respected."));
Thank You,
Chad