G
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 #6/6/2006#)) GROUP BY Tbl_masterpop.status ORDER BY
Format([popenterdt],'m/dd')PIVOT Format([popenterdt],'m/dd');
I would like to amend this query so that the query results are appended to
table as is. However, if the [popenterdate] is already in the table, it
should not be appended. For example, if there are records for [popenterdt]
of 6/1, the results should not be appended. How should I amend the query to
make this happen?
Thanks in advance,
geebee
TRANSFORM Count(Tbl_masterpop.[Loan Acct #]) AS [CountOfLoan Acct #]SELECT
Tbl_masterpop.status FROM Tbl_masterpop WHERE (([popenterdt] between
#6/1/2006# AND #6/6/2006#)) GROUP BY Tbl_masterpop.status ORDER BY
Format([popenterdt],'m/dd')PIVOT Format([popenterdt],'m/dd');
I would like to amend this query so that the query results are appended to
table as is. However, if the [popenterdate] is already in the table, it
should not be appended. For example, if there are records for [popenterdt]
of 6/1, the results should not be appended. How should I amend the query to
make this happen?
Thanks in advance,
geebee