query prompts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geebee - 19 Jul 2006 17:37 GMT

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

Reply to this Message

KARL DEWEY - 19 Jul 2006 19:14 GMT

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;

> I have the folowing query:
>
[quoted text clipped - 22 lines]
> Thanbks in advance,
> geebee

Reply to this Message

John Spencer - 19 Jul 2006 19:20 GMT

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 #])

>I have the folowing query:
>
[quoted text clipped - 24 lines]
> Thanbks in advance,
> geebee

Reply to this Message