DUPLICATE OUTPUT DESTINATION ERROR

[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];

 

[Tom van Stiphout]

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

 

[Mindy]

That worked~! Thanks a ton!

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];