append to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Thanks. I figured it out.


John Spencer said:
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.


geebee said:
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
Click to expand...
Click to expand...
 
Back
Top