Remove Enter Parameter Value dialogue boxes from query

I can't figure out how to remove the Enter Parameter Value dialogue
boxes from my query when I run the query?

I have checkboxes and am counting them.

That is, when checkbox is checked = -1

When checkbox is empty = 0

Any ideas?

Thanks,

John

Here is my code:

SELECT Sum(Abs([AgencyContactYes])) AS AgncyContYes, Sum(Abs
([AgencyContactNo])) AS AgncyContNo, Sum(Abs
([DaysBeforeHeardFromAgency1Week])) AS DaysBefreHrdFrmAgncy1Wk, Sum(Abs
([DaysBeforeHeardFromAgency2Weeks])) AS DaysBefreHrdFrmAgncy2Wks, Sum
(Abs([DaysBeforeHeardFromAgency3orMoreWeeks])) AS
DaysBefreHrdFrmAgncy3orMreWks, Sum(Abs([BecomeIBCCPClientYes])) AS
BecmeIBCCPClientYes, Sum(Abs([BecomeIBCCPClientNo])) AS
BecmeIBCCPClientNo, Sum(Abs([BecomeIBCCPClientDontKnow])) AS
BecmeIBCCPClientDontKnow, Sum(Abs([SatisfiedWithHelpReceivedYes])) AS
SatisfdWHlpRecvdYes, Sum(Abs([SatisfiedWithHelpReceivedNo])) AS
SatisfdWHlpRecvdNo, Sum(Abs([InNeedFurtherAssistanceYes])) AS
InNdFurthrAssistYes, Sum(Abs([InNeedFurtherAssistanceNo])) AS
InNdFurthrAssistNo, Sum(Abs([AgencyContactYes])+Abs
([AgencyContactNo])) AS AgncyContTL, Sum(Abs
([DaysBeforeHeardFromAgency1Week])+Abs
([DaysBeforeHeardFromAgency2Weeks])+Abs
([DaysBeforeHeardFromAgency3orMoreWeeks])) AS DaysBefreHrdFrmAgncyTL,
Sum(Abs([BecomeIBCCPClientYes])+Abs([BecomeIBCCPClientNo])+Abs
([BecomeIBCCPClientDontKnow])) AS BecmeIBCCPClientTL, Sum(Abs
([SatisfiedWithHelpReceivedYes])+Abs([SatisfiedWithHelpReceivedNo]))
AS SatisfdWHlpRecvdTL, Sum(Abs([InNeedFurtherAssistanceYes])+Abs
([InNeedFurtherAssistanceNo])) AS InNdFurthrAssistTL, [AgncyContYes]/
[AgncyContTL] AS PrcntAgncyContYes, [AgncyContNo]/[AgncyContTL] AS
PrcntAgncyContNo, [DaysBefreHrdFrmAgncy1Wk]/[DaysBefreHrdFrmAgncyTL]
AS PrcntDaysBefreHrdFrmAgncy1Wk, [DaysBefreHrdFrmAgncy2Wks]/
[DaysBefreHrdFrmAgncyTL] AS PrcntDaysBefreHrdFrmAgncy2Wks,
[DaysBefreHrdFrmAgncy3orMreWks]/[DaysBefreHrdFrmAgncyTL] AS
PrcntDaysBefreHrdFrmAgncy3orMreWks, [BecmeIBCCPClientYes]/
[BecmeIBCCPClientTL] AS PrcntBecmeIBCCPClientYes, [BecmeIBCCPClientNo]/
[BecmeIBCCPClientTL] AS PrcntBecmeIBCCPClientNo,
[BecmeIBCCPClientDontKnow]/[BecmeIBCCPClientTL] AS
PrcntBecmeIBCCPClientDontKnow, [SatisfdWHlpRecvdYes]/
[SatisfdWHlpRecvdTL] AS PrcntSatisfdWHlpRecvdYes, [SatisfdWHlpRecvdNo]/
[SatisfdWHlpRecvdTL] AS PrcntSatisfdWHlpRecvdNo, [InNdFurthrAssistYes]/
[InNdFurthrAssistTL] AS PrcntInNdFurthrAssistYes, [InNdFurthrAssistNo]/
[InNdFurthrAssistTL] AS PrcntInNdFurthrAssistNo
FROM [IBCCP Referral REPORT ONLY]
GROUP BY [AgncyContYes]/[AgncyContTL], [AgncyContNo]/[AgncyContTL],
[DaysBefreHrdFrmAgncy1Wk]/[DaysBefreHrdFrmAgncyTL],
[DaysBefreHrdFrmAgncy2Wks]/[DaysBefreHrdFrmAgncyTL],
[DaysBefreHrdFrmAgncy3orMreWks]/[DaysBefreHrdFrmAgncyTL],
[BecmeIBCCPClientYes]/[BecmeIBCCPClientTL], [BecmeIBCCPClientNo]/
[BecmeIBCCPClientTL], [BecmeIBCCPClientDontKnow]/[BecmeIBCCPClientTL],
[SatisfdWHlpRecvdYes]/[SatisfdWHlpRecvdTL], [SatisfdWHlpRecvdNo]/
[SatisfdWHlpRecvdTL], [InNdFurthrAssistYes]/[InNdFurthrAssistTL],
[InNdFurthrAssistNo]/[InNdFurthrAssistTL]
WITH OWNERACCESS OPTION;

Hi John,

When that dialog box comes up - it usually means there is something
wrong with the query. The query is pretty long - 29 calculated fields.
My suggestions would be to calculate just one field at a time in a new
query - or - you could calculate - say 5 or 6 fields at a time in this
new query. If the dialog box appears again in the new query then reduce
the number of fields (from left to right) until the new query does not
complain. Then you have isolated the problem field.

If the field(s) in the new query calculated correctly - then add
that/those field(s) to a "Main" query and then add the next set of
fields to this test query and test those fields out. This may seem
tedious, but it is the easiest way to isolate the problem field(s).

Rich

*** Sent via Developersdex http://www.developersdex.com ***