Getting request that a query have a destination field

[John Grinder]

I have an Access 2003 database query which pulls in data from Siebel and
deposits the results into a Excel file. In Access 2007 I get a message that
says "Query must have at least one destination field". It is error #3006. I
can find help on it which only states what the message says about needing a
destination field. I can not find anything useful in help about the
destination field requirements nor how to set one up in a query. Can someone
explain what needs done to make the 2003 query work in 2007? Thanks.

John

 

[Duane Hookom]

This error message is typical if you have an append query without selecting
any destination fields. Your SQL might look like:

INSERT INTO tblB
SELECT
FROM tblA;

If you can't figure this out, it is advisable to post your SQL view.

 

[John Grinder]

Below is what is shown when I do SQL view:
UPDATE dbo_S_SR_Test4CT INNER JOIN (TEST6_DEFECT INNER JOIN TEST6_INT ON
TEST6_DEFECT.PR_AFF_PRDINT_ID = TEST6_INT.ROW_ID) ON
dbo_S_SR_Test4CT.DEFECT_ID = TEST6_DEFECT.ROW_ID SET
WHERE (((TEST6_INT.PART_NUM)="lms-gn") AND ((TEST6_DEFECT.STATUS_CD)<>"In
Study" Or (TEST6_DEFECT.STATUS_CD)<>"Open" Or
(TEST6_DEFECT.STATUS_CD)<>"planned" Or (TEST6_DEFECT.STATUS_CD)<>"not
planned") AND ((TEST6_DEFECT.CREATED)>#11/1/2006#) AND
((TEST6_DEFECT.ACTUAL_FIX_DT)>#11/1/2006#) AND
((TEST6_DEFECT.DEFECT_TYPE_CD)<>"Non-SIR")) OR
(((TEST6_INT.PART_NUM)="MLAC-GN") AND ((TEST6_DEFECT.STATUS_CD)<>"In Study"
Or (TEST6_DEFECT.STATUS_CD)<>"Open" Or (TEST6_DEFECT.STATUS_CD)<>"planned" Or
(TEST6_DEFECT.STATUS_CD)<>"not planned") AND
((TEST6_DEFECT.CREATED)>#11/1/2006#) AND
((TEST6_DEFECT.ACTUAL_FIX_DT)>#11/1/2006#) AND
((TEST6_DEFECT.DEFECT_TYPE_CD)<>"Non-SIR")) OR
(((TEST6_INT.PART_NUM)="RVS-GN") AND ((TEST6_DEFECT.STATUS_CD)<>"In Study" Or
(TEST6_DEFECT.STATUS_CD)<>"Open" Or (TEST6_DEFECT.STATUS_CD)<>"planned" Or
(TEST6_DEFECT.STATUS_CD)<>"not planned") AND
((TEST6_DEFECT.CREATED)>#11/1/2006#) AND
((TEST6_DEFECT.ACTUAL_FIX_DT)>#11/1/2006#) AND
((TEST6_DEFECT.DEFECT_TYPE_CD)<>"Non-SIR")) OR
(((TEST6_INT.PART_NUM)="DSC-GN") AND ((TEST6_DEFECT.STATUS_CD)<>"In Study" Or
(TEST6_DEFECT.STATUS_CD)<>"Open" Or (TEST6_DEFECT.STATUS_CD)<>"planned" Or
(TEST6_DEFECT.STATUS_CD)<>"not planned") AND
((TEST6_DEFECT.CREATED)>#11/1/2006#) AND
((TEST6_DEFECT.ACTUAL_FIX_DT)>#11/1/2006#) AND
((TEST6_DEFECT.DEFECT_TYPE_CD)<>"Non-SIR"));
Please let me know if you need any further clarifying information. Thanks
for your assistance.
John

 

[Duane Hookom]

You have an update query that isn't updating any field values. The "UPDATE"
must have a "SET" followed by some field names and values:

UPDATE tblA
SET [FieldA]='SomeValue'
WHERE ...;