G
geebee
hi,
I have the following query:
TRANSFORM Count(Tbl_masterpop.[Loan Acct #]) AS [CountOfLoan Acct #]SELECT
Tbl_masterpop.status FROM Tbl_masterpop WHERE (([popenterdt] between
#6/1/2006# AND #9/19/2006#)) GROUP BY Tbl_masterpop.status ORDER BY
Format([popenterdt],'m/dd')PIVOT Format([popenterdt],'m/dd');
which basically puts the [status] in rows; and the [popenterdate], with
their respective status counts, in columns by [popenterdt]. I want to be
able to add the [countofstatus] column from tbl_account_counts for each
[popenterdt] and [status]. But the [countofstatus] just needs to appear in
parentheses in the same column the [countofstatus] is in. How can I do this?
Thanks in advance,
geebee
I have the following query:
TRANSFORM Count(Tbl_masterpop.[Loan Acct #]) AS [CountOfLoan Acct #]SELECT
Tbl_masterpop.status FROM Tbl_masterpop WHERE (([popenterdt] between
#6/1/2006# AND #9/19/2006#)) GROUP BY Tbl_masterpop.status ORDER BY
Format([popenterdt],'m/dd')PIVOT Format([popenterdt],'m/dd');
which basically puts the [status] in rows; and the [popenterdate], with
their respective status counts, in columns by [popenterdt]. I want to be
able to add the [countofstatus] column from tbl_account_counts for each
[popenterdt] and [status]. But the [countofstatus] just needs to appear in
parentheses in the same column the [countofstatus] is in. How can I do this?
Thanks in advance,
geebee