HELP! OUTER JOIN QUERY

I have an inner join query that works fine. But I want to make it
outer join, so I changed the "inner" to "left". It doesn't work! Here
is the query with problem:

SELECT PROD_RESULT.LOT_CREATED AS LOT_CREATED, TAs.[TA ABBRV] AS
TA_ON_SHIFT, Right(PROD_RESULT.VENDOR_LOT_NO,1) AS EVAP, "1" AS
BARREL, PROD_RESULT.TRANS_QTY AS WEIGHT, IIf(EVAP<"D","NORTH","SOUTH")
AS PLANT, "R" & PROD_RESULT.LOT_NO & "001001" AS LOTID, "001" AS LOT,
"001" AS SUB,
IIf(EVAP<"D",OPER_TEAM_RANGE.OPERATOR,OPER_TEAM_RANGE.OPERATOR2) AS
OPER, Val(Left(PROD_RESULT.VENDOR_LOT_NO,4)) AS RUN,
Right(PROD_RESULT.ITEM_NO,3) AS TYPE, OPER_TEAM_RANGE.TEAM AS TEAM

FROM OPER_TEAM_RANGE LEFT JOIN TAs ON OPER_TEAM_RANGE.TA=TAs.TA,
PROD_RESULT INNER JOIN RMCS_TRANS_ALL ON
(PROD_RESULT.LOT_NO=RMCS_TRANS_ALL.LOT_NO) AND
(PROD_RESULT.SUBLOT_NO=RMCS_TRANS_ALL.SUBLOT_NO)

WHERE (((PROD_RESULT.LOT_CREATED)<Forms!Rework_Update!endtxtField And
(PROD_RESULT.LOT_CREATED)>Forms!Rework_Update!begintxtField) And
((RMCS_TRANS_ALL.RMCS_FUNCTION)="RF - RI")) And
PROD_RESULT.LOT_CREATED>FORMAT(OPER_TEAM_RANGE.BEGIN,"MM/DD/YYYY
HH:NN:SS") And PROD_RESULT.LOT_CREATED<FORMAT(OPER_TEAM_RANGE.END,"MM/
DD/YYYY HH:NN:SS")
ORDER BY PROD_RESULT.LOT_CREATED;
.

Relevant Pages

  • Re: how to add new record with inner join
    ... rather than basing your form on the inner join query. ... You don't need special code to ... How do I enable edits in all of the fields? ...
    (microsoft.public.access.formscoding)
  • Re: inner join update and query differences
    ... "David Gugick" wrote: ... >> I have an inner join query to pull all records that match a specific ... > UPDATE stkhst ...
    (microsoft.public.sqlserver.programming)
  • RE: cross reference tables using a query
    ... that were not matched to any entry in the phone numbers and person name ... I have tried reversing the INNER JOIN Query but without success. ... >>> I have two tables that I am trying to cross reference. ...
    (microsoft.public.access.queries)
  • Help! Outer Join problem
    ... I have an inner join query that works fine. ... BARREL, PROD_RESULT.TRANS_QTY AS WEIGHT, ... "001" AS SUB, ...
    (microsoft.public.access.queries)
  • Re: sorting between two spreadsheets
    ... An Excel worksheet is limited to about 65536 rows, ... > perform the INNER JOIN query. ... > You can link an Excel spreadsheet into Access through the File menu, ...
    (comp.databases.ms-access)