query addition

[Guest]

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

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm not sure, but I believe you can do something like this in the
TRANSFORM clause:

TRANSFORM Count(Tbl_masterpop.[Load Acct #]) & " (" & Count(status) &
")" As theValue
SELECT ... etc.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRJmXxYechKqOuFEgEQL6WACgtoF2iBFNmlzocGQUPIbmNsq0KQUAoOJB
+DC/Y8Ejw6JGbTrhsFSOB4Df
=vzqe
-----END PGP SIGNATURE-----