DUPLICATE OUTPUT DESTINATION ERROR

  • Thread starter Thread starter Mindy
  • Start date Start date
M

Mindy

I'm really hoping someone can help me--I am about to pull my hair out! I am
all of the sudden having trouble with a query that has been set up for years
& I use every month with no problems.
I am creating a query--appending 2 tables together; then I run calculation
queries from the "appended to" table. I'm getting stuck on my first
query--which typically does not happen, so I don't know what is going on.
Here is my SQL (which I've never messed with before!) Thanks to anyone who
can help!

INSERT INTO [Download From PA] ( ID, Customer, Document, [End User],
[Ship-to Party], [Invoice Date], ProdHier6, Product, Tons, [Invoice $],
[Reference Item], [Sales Order Item] )
SELECT [Period 3 2009].*, [Period 3 2009].ID, [Period 3 2009].[Customer ],
[Period 3 2009].Document, [Period 3 2009].[End user], [Period 3
2009].[Ship-to Party], [Period 3 2009].[Invoice Date], [Period 3
2009].ProdHier6, [Period 3 2009].Product, [Period 3 2009].Tons, [Period 3
2009].[Invoice $], [Period 3 2009].[Reference Item], [Period 3 2009].[Sales
Order Item]
FROM [Period 3 2009];
 
On Thu, 2 Apr 2009 05:47:01 -0700, Mindy

It seems you have an extra argument in the SELECT clause. Replace:
SELECT [Period 3 2009].*,
with:
SELECT

-Tom.
Microsoft Access MVP
 
That worked~! Thanks a ton!

Tom van Stiphout said:
On Thu, 2 Apr 2009 05:47:01 -0700, Mindy

It seems you have an extra argument in the SELECT clause. Replace:
SELECT [Period 3 2009].*,
with:
SELECT

-Tom.
Microsoft Access MVP
I'm really hoping someone can help me--I am about to pull my hair out! I am
all of the sudden having trouble with a query that has been set up for years
& I use every month with no problems.
I am creating a query--appending 2 tables together; then I run calculation
queries from the "appended to" table. I'm getting stuck on my first
query--which typically does not happen, so I don't know what is going on.
Here is my SQL (which I've never messed with before!) Thanks to anyone who
can help!

INSERT INTO [Download From PA] ( ID, Customer, Document, [End User],
[Ship-to Party], [Invoice Date], ProdHier6, Product, Tons, [Invoice $],
[Reference Item], [Sales Order Item] )
SELECT [Period 3 2009].*, [Period 3 2009].ID, [Period 3 2009].[Customer ],
[Period 3 2009].Document, [Period 3 2009].[End user], [Period 3
2009].[Ship-to Party], [Period 3 2009].[Invoice Date], [Period 3
2009].ProdHier6, [Period 3 2009].Product, [Period 3 2009].Tons, [Period 3
2009].[Invoice $], [Period 3 2009].[Reference Item], [Period 3 2009].[Sales
Order Item]
FROM [Period 3 2009];
Click to expand...
Click to expand...
 
Back
Top