EXCELL SQL statement that won't work for ACCESS

J

jackle

Is there a reason why an SQL statement for an Excell spreadsheet won't work
in Access? The Excell statement only takes a second or two to bring up data
in Excell 2002, but chokes in Access 2002 (it times out, eventually).

the gist of the statement is below. the queery would have to recive the
actual work order number from a text or combo box. that segment is finished.
and I am not sure how to get the text/combo box to plug that into the
statement. Any direction is appreciated. THANKS.

SELECT dbo_ViewWOstatWhoWanded.WORK_ORDER, dbo_ViewWOstatWhoWanded.ITEM_NBR,
dbo_WIP_OPERATION_ACTIVITY.OP_COMP_DATE,
dbo_WIP_OPERATION_ACTIVITY.OPERATION_NBR,
dbo_WIP_OPERATION_ACTIVITY.SEQUENCE_NBR,
dbo_WIP_OPERATION_ACTIVITY.QTY_COMPLETE,
dbo_WIP_OPERATION_ACTIVITY.QTY_SCRAP, dbo_ViewWOstatWhoWanded.DEPARTMENT,
dbo_ViewWOstatWhoWanded.USER_ID, dbo_ViewWOstatWhoWanded.USER_NAME,
dbo_ViewWOstatWhoWanded.ENTRY_DATE, dbo_WIP_OPERATION_ACTIVITY.OPER_DESC,
dbo_WIP_OPERATION_ACTIVITY.OPER_INSTRUCTIONS,
dbo_ViewWOstatWhoWanded.job_line_nbr
FROM dbo_ViewWOstatWhoWanded INNER JOIN dbo_WIP_OPERATION_ACTIVITY ON
(dbo_ViewWOstatWhoWanded.OPERATION_NBR =
dbo_WIP_OPERATION_ACTIVITY.OPERATION_NBR) AND
(dbo_ViewWOstatWhoWanded.WORK_ORDER = dbo_WIP_OPERATION_ACTIVITY.WORK_ORDER);
 
Top