Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate Output Destination

Status
Not open for further replies.

rwn

Technical User
Joined
Dec 14, 2002
Messages
420
Location
US
I'm trying to create an append query to add routing sequence steps for new routings. When I run the query it state duplicate output destination, I understand the message for it is indicating that some part routings already have a sequence 40. I need to have the append query disregard those part routings and only append the query to part routings without a sequence 40. Thank you in advance!

The query is as below:
INSERT INTO [Part Routing] ( PRTNUM_12, OPRSEQ_12, WRKCTR_12, OPRDES_12 )
SELECT [Part Routing].PRTNUM_12, "60" AS Expr1, "LAB" AS Expr2, "LAB" AS Expr3
FROM [Part Routing]
WHERE ((([Part Routing].PRTNUM_12)="000001") AND (([Part Routing].OPRSEQ_12)="40"));
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top