append to table

[Guest]

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

 

[John Spencer]

What does the table you are appending to look like?

Are you appending the entire contents of this query into the table you are
appending to?

It would seem to be impossible to do so, since the field names would vary by
month.

 

[Guest]

Thanks. I figured it out.

What does the table you are appending to look like?

Are you appending the entire contents of this query into the table you are
appending to?

It would seem to be impossible to do so, since the field names would vary by
month.

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