Getting request that a query have a destination field

  • Thread starter Thread starter John Grinder
  • Start date Start date
J

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
 
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.
 
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
 
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 ...;
 
Back
Top