query prompts

[Guest]

I have the folowing query:

SELECT tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus,
tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt,
Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.[CountOfLoan Acct #])
AS SumOfResolved, "line5" AS line, [1calltotals].[SumOfCOUNT( * )] AS
SumOfCalls, [SumOfCalls]/[SumOfResolved] AS Expr1
FROM tbl_CACS_activity_by_resolvedstatusandcontactcode INNER JOIN
1calltotals ON (tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt
= [1calltotals].ResolvedDt) AND
(tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus =
[1calltotals].ResolvedStatus)
WHERE (((tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus)
Like "curr_pd*"))
GROUP BY tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus,
tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt,
[1calltotals].[SumOfCOUNT( * )], [SumOfCalls]/[SumOfResolved];

BUT, I am getting 2 prompts:
1: [SumOfCalls]
2: [SumOfResolved]

How can I prevent getting these prompts?

Thanbks in advance,
geebee

 

[Guest]

Try this --
SELECT tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus,
tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt,
Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.[CountOfLoan Acct #])
AS SumOfResolved, "line5" AS line, [1calltotals].[SumOfCOUNT( * )] AS
SumOfCalls, [1calltotals].[SumOfCOUNT( *
)]/Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.[CountOfLoan Acct
#]) AS Expr1
FROM tbl_CACS_activity_by_resolvedstatusandcontactcode INNER JOIN
1calltotals ON (tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt
= [1calltotals].ResolvedDt) AND
(tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus =
[1calltotals].ResolvedStatus)
WHERE (((tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus)
Like "curr_pd*"))
GROUP BY tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus,
tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt,
[1calltotals].[SumOfCOUNT( * )], Expr1;

 

[John Spencer]

One method would be to redo the calculations

SELECT tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus,
tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt,
Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.[CountOfLoan Acct #])
AS SumOfResolved,
"line5" AS line
, [1calltotals].[SumOfCOUNT( * )] AS SumOfCalls,
[1calltotals].[SumOfCOUNT( * )]
/Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.[CountOfLoan Acct #])
AS Expr1
FROM tbl_CACS_activity_by_resolvedstatusandcontactcode INNER JOIN
1calltotals ON (tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt
= [1calltotals].ResolvedDt) AND
(tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus =
[1calltotals].ResolvedStatus)
WHERE (((tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus)
Like "curr_pd*"))
GROUP BY tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus,
tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt,
[1calltotals].[SumOfCOUNT( * )]
/Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.[CountOfLoan Acct #])