I have a query that was written in SQL. I need to bring the query into Access and am having a lot of trouble with the left joins. I'm getting a lot of errors saying missing expression, etc... Could some one help me convert this to something Access understands?
INNER JOIN QUOTE_ITEM QI ON QI.QUOTE_ID = Q.QUOTE_ID
AND QI.QUOTE_VERS_STOP = Q.QUOTE_VERS
INNER JOIN BOM_PIECE BP ON QI.QUOTE_ITEM_ID = BP.QUOTE_ITEM_ID
INNER JOIN EXTN EX ON BP.EXTN_LIB_ID = EX.EXTN_LIB_ID
AND BP.EXTN_ID = EX.EXTN_ID
INNER JOIN CLASSIFICATION CL ON EX.CLASSIF_LIB_ID = CL.CLASSIF_LIB_ID
AND EX.CLASSIF_ID = CL.CLASSIF_ID
LEFT JOIN BOM_MIL BM ON BM.QUOTE_ITEM_ID = BP.QUOTE_ITEM_ID
AND BM.INSTANCE_IDENT = BP.INSTANCE_IDENT
AND BM.OBJ_ID = BP.OBJ_ID
LEFT JOIN MILLING M ON M.MIL_LIB_ID = BM.MIL_LIB_ID
AND M.MIL_ID = BM.MIL_ID
We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.
The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…