Hello,

I wonder if anyone can help me. I have a problem which I think is query related. I have a query which reads the date from a form text box (which works OK in other queries). For some reason when this query runs, it crashes Access and makes a backup of the database. Can anyone see where Im going wrong? Thanks (SQL below).


SELECT dbo_MG_BILL_OF_LADING.CREATE_DT, dbo_MG_BILL_OF_LADING.BL_NUM, dbo_MG_BILL_OF_LADING.BL_ID, dbo_MG_BL_ITINERARY.BL_ITINERARY_ID, dbo_MG_BL_ITINERARY.SERVICE_CD, dbo_MG_BILL_OF_LADING.TRADE_CD, dbo_MG_BILL_OF_LADING.POR_LOCATION_CD, dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD INTO DB_MOTHER_DECISION_TRUNK
FROM ((((dbo_MG_LOCATION INNER JOIN (dbo_MG_BILL_OF_LADING INNER JOIN dbo_MG_BL_ITINERARY ON dbo_MG_BILL_OF_LADING.BL_ID = dbo_MG_BL_ITINERARY.BL_ID) ON dbo_MG_LOCATION.LOCATION_CD = dbo_MG_BL_ITINERARY.FROM_LOCATION_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_1 ON dbo_MG_BL_ITINERARY.TO_LOCATION_CD = dbo_MG_LOCATION_1.LOCATION_CD) INNER JOIN dbo_MG_SERVICE ON dbo_MG_BL_ITINERARY.SERVICE_CD = dbo_MG_SERVICE.SERVICE_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_2 ON dbo_MG_BILL_OF_LADING.POR_LOCATION_CD = dbo_MG_LOCATION_2.LOCATION_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_3 ON dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD = dbo_MG_LOCATION_3.LOCATION_CD
WHERE (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"));

What version of SQL are you using?
Also, can I suggest that you nest your code so that it's a lot easier to read, it makes tracking down problems so much easier, espeically as Analyser will only return a row number and value for the errors it finds.

Thanks for looking.
Im using Access 2003 (not sure how to see what SQL that is).
I don't know how to nest the code or even what Analyser is (im guessing a program?).
Thanks for further advice :)

Hello again... Still having big problems with this... can anyone help? Thanks

I think you need to compile your script and see where it's falling over. It sounds like what's happening is that something in the code is not working properly which is causing the whole database to crash. When the database crashes Access will make a "backup" of it for your convenience.

Do you know how to compile the code?

Hi again - Thanks - I dont know how to compile code (Im self taught so I only know what Ive needed in the past). Please can you advise me?

OK, I'll try, give me a minute while I sort something else out.

When you are in the code window, just pick Debug>compile . . . Is that what you were asking?

When I view my Access query in Access SQL, I cant see an option for Debug or compile. I have that option in VB editor but arent they seperate things?

Yes they are separate things. When you are in the code window, (Alt+F11), that is where you can compile. To compile a single query, just open it in design view and run it - then it will be compiled. I'm not really sure what your issue is, Ouma just asked me to reply to you because she doesn't have time right now . . . what are you trying to accomplish?

Thank you. I have a query which needs the date changing a lot - SQL below - To save time Ive tied it to a form to change the date easily. But when the query runs, it crashed Access and creates the backup. I cant see whats wrong with it cause another - less complex query is working just fine. Thanks for any help.
(sorry if its hard to read - i dont know how else to paste it).


SELECT dbo_MG_BILL_OF_LADING.CREATE_DT, dbo_MG_BILL_OF_LADING.BL_NUM, dbo_MG_BILL_OF_LADING.BL_ID, dbo_MG_BL_ITINERARY.BL_ITINERARY_ID, dbo_MG_BL_ITINERARY.SERVICE_CD, dbo_MG_BILL_OF_LADING.TRADE_CD, dbo_MG_BILL_OF_LADING.POR_LOCATION_CD, dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD INTO DB_MOTHER_DECISION_TRUNK
FROM ((((dbo_MG_LOCATION INNER JOIN (dbo_MG_BILL_OF_LADING INNER JOIN dbo_MG_BL_ITINERARY ON dbo_MG_BILL_OF_LADING.BL_ID = dbo_MG_BL_ITINERARY.BL_ID) ON dbo_MG_LOCATION.LOCATION_CD = dbo_MG_BL_ITINERARY.FROM_LOCATION_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_1 ON dbo_MG_BL_ITINERARY.TO_LOCATION_CD = dbo_MG_LOCATION_1.LOCATION_CD) INNER JOIN dbo_MG_SERVICE ON dbo_MG_BL_ITINERARY.SERVICE_CD = dbo_MG_SERVICE.SERVICE_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_2 ON dbo_MG_BILL_OF_LADING.POR_LOCATION_CD = dbo_MG_LOCATION_2.LOCATION_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_3 ON dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD = dbo_MG_LOCATION_3.LOCATION_CD
WHERE (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="LAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="LAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"I1" And (dbo_MG_SERVICE.LINE_CD)<>"I2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"I1" And (dbo_MG_SERVICE.LINE_CD)<>"I2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="I1" Or (dbo_MG_SERVICE.LINE_CD)="I2") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)="ES") AND ((dbo_MG_LOCATION_3.COUNTRY_CD)="PT" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="ES" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="FR" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="DE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="NL" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="BE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="GB" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="IE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="NO" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="FI" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="SE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="PO" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="CZ" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="CH" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="RU" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="EE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="AT" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="DK")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="I1" Or (dbo_MG_SERVICE.LINE_CD)="I2") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)="PT" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="ES" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="FR" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="DE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="NL" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="BE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="GB" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="IE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="NO" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="FI" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="SE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="PO" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="CZ" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="CH" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="RU" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="EE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="AT" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="DK") AND ((dbo_MG_LOCATION_3.COUNTRY_CD)="ES")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD) Not Like "T*") AND ((dbo_MG_BILL_OF_LADING.VESSEL_CD)<>"ESW" And (dbo_MG_BILL_OF_LADING.VESSEL_CD)<>"ESQ")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="I1") AND ((dbo_MG_BILL_OF_LADING.VESSEL_CD)="ESW" Or (dbo_MG_BILL_OF_LADING.VESSEL_CD)="ESQ")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IASA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="E1" Or (dbo_MG_SERVICE.LINE_CD)="E2" Or (dbo_MG_SERVICE.LINE_CD)="E3" Or (dbo_MG_SERVICE.LINE_CD)="ED" Or (dbo_MG_SERVICE.LINE_CD)="E6" Or (dbo_MG_SERVICE.LINE_CD)="E7" Or (dbo_MG_SERVICE.LINE_CD)="E8" Or (dbo_MG_SERVICE.LINE_CD)="E9" Or (dbo_MG_SERVICE.LINE_CD)="A2" Or (dbo_MG_SERVICE.LINE_CD)="AM" Or (dbo_MG_SERVICE.LINE_CD)="AB" Or (dbo_MG_SERVICE.LINE_CD)="DX" Or (dbo_MG_SERVICE.LINE_CD)="IE" Or (dbo_MG_SERVICE.LINE_CD)="E5" Or (dbo_MG_SERVICE.LINE_CD)="I1" Or (dbo_MG_SERVICE.LINE_CD)="I2" Or (dbo_MG_SERVICE.LINE_CD)="I4" Or (dbo_MG_SERVICE.LINE_CD)="CX" Or (dbo_MG_SERVICE.LINE_CD)="MX" Or (dbo_MG_SERVICE.LINE_CD)="BF" Or (dbo_MG_SERVICE.LINE_CD)="A4" Or (dbo_MG_SERVICE.LINE_CD)="A1" Or (dbo_MG_SERVICE.LINE_CD)="s2" Or (dbo_MG_SERVICE.LINE_CD)="ex" Or (dbo_MG_SERVICE.LINE_CD)="U1" Or (dbo_MG_SERVICE.LINE_CD)="U2" Or (dbo_MG_SERVICE.LINE_CD)="EH" Or (dbo_MG_SERVICE.LINE_CD)="EN" Or (dbo_MG_SERVICE.LINE_CD)="BX" Or (dbo_MG_SERVICE.LINE_CD)="XD") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD]) AND ((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD])) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IASA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="P1" Or (dbo_MG_SERVICE.LINE_CD)="P3" Or (dbo_MG_SERVICE.LINE_CD)="P6" Or (dbo_MG_SERVICE.LINE_CD)="P7" Or (dbo_MG_SERVICE.LINE_CD)="P9" Or (dbo_MG_SERVICE.LINE_CD)="P5" Or (dbo_MG_SERVICE.LINE_CD)="PA") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD]) AND ((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD]) AND ((dbo_MG_BL_ITINERARY.LEG_CD)="W")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD) Not Like "T*") AND ((dbo_MG_LOCATION.COUNTRY_CD)="ES") AND ((dbo_MG_LOCATION_1.COUNTRY_CD)<>"ES")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD) Not Like "T*") AND ((dbo_MG_LOCATION.COUNTRY_CD)<>"ES") AND ((dbo_MG_LOCATION_1.COUNTRY_CD)="ES")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD) Not Like "T*") AND ((dbo_MG_LOCATION.COUNTRY_CD)<>"ES") AND ((dbo_MG_LOCATION_1.COUNTRY_CD)<>"ES")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ISWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="IE" Or (dbo_MG_SERVICE.LINE_CD)="A4") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD]) AND ((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD])) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_BL_ITINERARY.TO_LOCATION_CD)="EGAIS")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_BL_ITINERARY.FROM_LOCATION_CD)="EGAIS")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.POR_LOCATION_CD)="SAJED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="A4" Or (dbo_MG_SERVICE.LINE_CD)="A2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD)="SAJED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="A4" Or (dbo_MG_SERVICE.LINE_CD)="A2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="SN")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="SN")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="SN")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="SN")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="S2" Or (dbo_MG_SERVICE.LINE_CD)="U1" Or (dbo_MG_SERVICE.LINE_CD)="U2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date]) AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="LAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="S2" Or (dbo_MG_SERVICE.LINE_CD)="U1" Or (dbo_MG_SERVICE.LINE_CD)="U2"));

That query is just way way way too long for anyone to read all the way through, which is going to make it much harder for anyone to help you. Can you go between design view and SQL view with no problems (the SQL editor will catch basic syntax errors for you when you do this). If that works, the next thing I would check is that the way you are referring to the value on the form is returning the value that you expect. So in the immediate window, (go to code editor, then do ctrl+g), type this: ? [Forms]![TS_FRT]![Date] and then type enter, see if the answer that spits out is correct. Double check any other variable inputs as well. If neither of those things helps you find the problem, post back and I will think of some other things for you to check.

HTH

That's one helluva WHERE clause you've got there. I'd look at that first.

It LOOKS like you have some common fields after every OR. You should be able to use those just once. You could probably fix some others with IN


WHERE dbo_MG_BILL_OF_LADING.CREATE_DT>=[Forms]![TS_FRT]![Date]
AND dbo_MG_SERVICE.VESSEL_TYPE_CD="CONT"
AND dbo_MG_BILL_OF_LADING.DELETED_FLG="N"
AND dbo_MG_BILL_OF_LADING.TRADE_CD IN ("ASAEUR", "ASAMED")
AND dbo_MG_LOCATION.CONTINENT_CD IN ("MED","EUR")
...

Thank you both...

Alisa - I can swap view without any error. When I try the immediate window it sawy "Run time error 2450 - Cant find TS_FRT ref'd to in macro expression or VB code."
TS_FRT is my form name and i doubled check the spelling ETC.

the form needs to be open. open it and enter values as you would like to - add values or go to a valid record - then check the vbeditor again to see if it reads the values from the open form.

Thanks! The form wasnt open and now it is returning the value I entered... I guess that means that the form is readable?

To add some more (hopefully) useful info... The query runs fine as a SELECT query, but when I run it as a MAKE TABLE query, it crashes the system... has this been heard of before?
Thanks

What is the error you get when you run it as a make table query? Does the whole thing just crash? What is the name of the table you are making?

When I run it as MAKE TABLE, the whole thing just crashes, closes, restarts, and makes a backup of the database. Its very odd. The table was orig called "DB_MOTHER_ASSIGN" but ive tried using other table names too... ones that already exist and ones that dont yet exist.

Can you post your make table query? (I only see the select query above)

Sorry - I thought that was the make table i posted before...

Thank you so much for your time helping me with this.


SELECT dbo_MG_BILL_OF_LADING.CREATE_DT, dbo_MG_BILL_OF_LADING.BL_NUM, dbo_MG_BILL_OF_LADING.BL_ID, dbo_MG_BL_ITINERARY.BL_ITINERARY_ID, dbo_MG_BL_ITINERARY.SERVICE_CD, dbo_MG_BILL_OF_LADING.TRADE_CD, dbo_MG_BILL_OF_LADING.POR_LOCATION_CD, dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD INTO DB_MOTHER_DECISION_TRUNK
FROM ((((dbo_MG_LOCATION INNER JOIN (dbo_MG_BILL_OF_LADING INNER JOIN dbo_MG_BL_ITINERARY ON dbo_MG_BILL_OF_LADING.BL_ID = dbo_MG_BL_ITINERARY.BL_ID) ON dbo_MG_LOCATION.LOCATION_CD = dbo_MG_BL_ITINERARY.FROM_LOCATION_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_1 ON dbo_MG_BL_ITINERARY.TO_LOCATION_CD = dbo_MG_LOCATION_1.LOCATION_CD) INNER JOIN dbo_MG_SERVICE ON dbo_MG_BL_ITINERARY.SERVICE_CD = dbo_MG_SERVICE.SERVICE_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_2 ON dbo_MG_BILL_OF_LADING.POR_LOCATION_CD = dbo_MG_LOCATION_2.LOCATION_CD) INNER JOIN dbo_MG_LOCATION AS dbo_MG_LOCATION_3 ON dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD = dbo_MG_LOCATION_3.LOCATION_CD
WHERE (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="LAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="LAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"I1" And (dbo_MG_SERVICE.LINE_CD)<>"I2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"I1" And (dbo_MG_SERVICE.LINE_CD)<>"I2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="I1" Or (dbo_MG_SERVICE.LINE_CD)="I2") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)="ES") AND ((dbo_MG_LOCATION_3.COUNTRY_CD)="PT" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="ES" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="FR" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="DE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="NL" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="BE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="GB" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="IE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="NO" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="FI" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="SE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="PO" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="CZ" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="CH" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="RU" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="EE" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="AT" Or (dbo_MG_LOCATION_3.COUNTRY_CD)="DK")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="I1" Or (dbo_MG_SERVICE.LINE_CD)="I2") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)="PT" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="ES" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="FR" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="DE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="NL" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="BE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="GB" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="IE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="NO" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="FI" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="SE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="PO" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="CZ" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="CH" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="RU" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="EE" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="AT" Or (dbo_MG_LOCATION_2.COUNTRY_CD)="DK") AND ((dbo_MG_LOCATION_3.COUNTRY_CD)="ES")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD) Not Like "T*") AND ((dbo_MG_BILL_OF_LADING.VESSEL_CD)<>"ESW" And (dbo_MG_BILL_OF_LADING.VESSEL_CD)<>"ESQ")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IEUR") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="I1") AND ((dbo_MG_BILL_OF_LADING.VESSEL_CD)="ESW" Or (dbo_MG_BILL_OF_LADING.VESSEL_CD)="ESQ")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IASA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="E1" Or (dbo_MG_SERVICE.LINE_CD)="E2" Or (dbo_MG_SERVICE.LINE_CD)="E3" Or (dbo_MG_SERVICE.LINE_CD)="ED" Or (dbo_MG_SERVICE.LINE_CD)="E6" Or (dbo_MG_SERVICE.LINE_CD)="E7" Or (dbo_MG_SERVICE.LINE_CD)="E8" Or (dbo_MG_SERVICE.LINE_CD)="E9" Or (dbo_MG_SERVICE.LINE_CD)="A2" Or (dbo_MG_SERVICE.LINE_CD)="AM" Or (dbo_MG_SERVICE.LINE_CD)="AB" Or (dbo_MG_SERVICE.LINE_CD)="DX" Or (dbo_MG_SERVICE.LINE_CD)="IE" Or (dbo_MG_SERVICE.LINE_CD)="E5" Or (dbo_MG_SERVICE.LINE_CD)="I1" Or (dbo_MG_SERVICE.LINE_CD)="I2" Or (dbo_MG_SERVICE.LINE_CD)="I4" Or (dbo_MG_SERVICE.LINE_CD)="CX" Or (dbo_MG_SERVICE.LINE_CD)="MX" Or (dbo_MG_SERVICE.LINE_CD)="BF" Or (dbo_MG_SERVICE.LINE_CD)="A4" Or (dbo_MG_SERVICE.LINE_CD)="A1" Or (dbo_MG_SERVICE.LINE_CD)="s2" Or (dbo_MG_SERVICE.LINE_CD)="ex" Or (dbo_MG_SERVICE.LINE_CD)="U1" Or (dbo_MG_SERVICE.LINE_CD)="U2" Or (dbo_MG_SERVICE.LINE_CD)="EH" Or (dbo_MG_SERVICE.LINE_CD)="EN" Or (dbo_MG_SERVICE.LINE_CD)="BX" Or (dbo_MG_SERVICE.LINE_CD)="XD") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD]) AND ((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD])) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IASA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="P1" Or (dbo_MG_SERVICE.LINE_CD)="P3" Or (dbo_MG_SERVICE.LINE_CD)="P6" Or (dbo_MG_SERVICE.LINE_CD)="P7" Or (dbo_MG_SERVICE.LINE_CD)="P9" Or (dbo_MG_SERVICE.LINE_CD)="P5" Or (dbo_MG_SERVICE.LINE_CD)="PA") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD]) AND ((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD]) AND ((dbo_MG_BL_ITINERARY.LEG_CD)="W")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD) Not Like "T*") AND ((dbo_MG_LOCATION.COUNTRY_CD)="ES") AND ((dbo_MG_LOCATION_1.COUNTRY_CD)<>"ES")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD) Not Like "T*") AND ((dbo_MG_LOCATION.COUNTRY_CD)<>"ES") AND ((dbo_MG_LOCATION_1.COUNTRY_CD)="ES")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)<>"MF" And (dbo_MG_SERVICE.LINE_CD)<>"EF" And (dbo_MG_SERVICE.LINE_CD) Not Like "T*") AND ((dbo_MG_LOCATION.COUNTRY_CD)<>"ES") AND ((dbo_MG_LOCATION_1.COUNTRY_CD)<>"ES")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ISWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="IE" Or (dbo_MG_SERVICE.LINE_CD)="A4") AND ((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD]) AND ((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD])) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_BL_ITINERARY.TO_LOCATION_CD)="EGAIS")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_BL_ITINERARY.FROM_LOCATION_CD)="EGAIS")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.POR_LOCATION_CD)="SAJED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="A4" Or (dbo_MG_SERVICE.LINE_CD)="A2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD)="SAJED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="A4" Or (dbo_MG_SERVICE.LINE_CD)="A2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="SN")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAUSEC") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="NAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="SN")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION.CONTINENT_CD)="SWA") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="MED") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="SN")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED") AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA" Or (dbo_MG_LOCATION_1.CONTINENT_CD)="SWA") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="SN")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="S2" Or (dbo_MG_SERVICE.LINE_CD)="U1" Or (dbo_MG_SERVICE.LINE_CD)="U2")) OR (((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![FromCBO]) AND ((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT") AND ((dbo_MG_LOCATION.CONTINENT_CD)="LAM") AND ((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR") AND ((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_SERVICE.LINE_CD)="S2" Or (dbo_MG_SERVICE.LINE_CD)="U1" Or (dbo_MG_SERVICE.LINE_CD)="U2"));

You are right - I was just confused, sorry. I am a little perplexed though, I have never had a query that ran just fine as a select query, but that failed as a make table query. Do you think it could be a memory issue? Another thing I might test, just for fun, is to create the table by hand, then change it the query to an append query to your new table, and see if that sheds any light on what is going on.

Here's a formatted version of the query, for what it's worth:

DELETE
_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="ASA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="SWA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="SWA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="ASA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="ASA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="SWA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="SWA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="NAM")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="MEDUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="NAM")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="NAM")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="NAM")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="LAM")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="LAM")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURWCSA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)<>"EF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"MF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"I1"
AND
(dbo_MG_SERVICE.LINE_CD)<>"I2"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)<>"EF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"MF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"I1"
AND
(dbo_MG_SERVICE.LINE_CD)<>"I2"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="I1"
OR
(dbo_MG_SERVICE.LINE_CD)="I2")
AND
((dbo_MG_LOCATION_2.COUNTRY_CD)="ES")
AND
((dbo_MG_LOCATION_3.COUNTRY_CD)="PT"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="ES"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="FR"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="DE"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="NL"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="BE"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="GB"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="IE"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="NO"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="FI"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="SE"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="PO"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="CZ"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="CH"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="RU"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="EE"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="AT"
OR
(dbo_MG_LOCATION_3.COUNTRY_CD)="DK"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="EURMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="I1"
OR
(dbo_MG_SERVICE.LINE_CD)="I2")
AND
((dbo_MG_LOCATION_2.COUNTRY_CD)="PT"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="ES"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="FR"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="DE"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="NL"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="BE"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="GB"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="IE"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="NO"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="FI"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="SE"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="PO"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="CZ"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="CH"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="RU"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="EE"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="AT"
OR
(dbo_MG_LOCATION_2.COUNTRY_CD)="DK")
AND
((dbo_MG_LOCATION_3.COUNTRY_CD)="ES"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)<>"EF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"MF"
AND
(dbo_MG_SERVICE.LINE_CD) Not Like "T*")
AND
((dbo_MG_BILL_OF_LADING.VESSEL_CD)<>"ESW"
AND
(dbo_MG_BILL_OF_LADING.VESSEL_CD)<>"ESQ"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IEUR")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="I1")
AND
((dbo_MG_BILL_OF_LADING.VESSEL_CD)="ESW"
OR
(dbo_MG_BILL_OF_LADING.VESSEL_CD)="ESQ"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IASA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="E1"
OR
(dbo_MG_SERVICE.LINE_CD)="E2"
OR
(dbo_MG_SERVICE.LINE_CD)="E3"
OR
(dbo_MG_SERVICE.LINE_CD)="ED"
OR
(dbo_MG_SERVICE.LINE_CD)="E6"
OR
(dbo_MG_SERVICE.LINE_CD)="E7"
OR
(dbo_MG_SERVICE.LINE_CD)="E8"
OR
(dbo_MG_SERVICE.LINE_CD)="E9"
OR
(dbo_MG_SERVICE.LINE_CD)="A2"
OR
(dbo_MG_SERVICE.LINE_CD)="AM"
OR
(dbo_MG_SERVICE.LINE_CD)="AB"
OR
(dbo_MG_SERVICE.LINE_CD)="DX"
OR
(dbo_MG_SERVICE.LINE_CD)="IE"
OR
(dbo_MG_SERVICE.LINE_CD)="E5"
OR
(dbo_MG_SERVICE.LINE_CD)="I1"
OR
(dbo_MG_SERVICE.LINE_CD)="I2"
OR
(dbo_MG_SERVICE.LINE_CD)="I4"
OR
(dbo_MG_SERVICE.LINE_CD)="CX"
OR
(dbo_MG_SERVICE.LINE_CD)="MX"
OR
(dbo_MG_SERVICE.LINE_CD)="BF"
OR
(dbo_MG_SERVICE.LINE_CD)="A4"
OR
(dbo_MG_SERVICE.LINE_CD)="A1"
OR
(dbo_MG_SERVICE.LINE_CD)="s2"
OR
(dbo_MG_SERVICE.LINE_CD)="ex"
OR
(dbo_MG_SERVICE.LINE_CD)="U1"
OR
(dbo_MG_SERVICE.LINE_CD)="U2"
OR
(dbo_MG_SERVICE.LINE_CD)="EH"
OR
(dbo_MG_SERVICE.LINE_CD)="EN"
OR
(dbo_MG_SERVICE.LINE_CD)="BX"
OR
(dbo_MG_SERVICE.LINE_CD)="XD")
AND
((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD])
AND
((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD]))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IASA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="P1"
OR
(dbo_MG_SERVICE.LINE_CD)="P3"
OR
(dbo_MG_SERVICE.LINE_CD)="P6"
OR
(dbo_MG_SERVICE.LINE_CD)="P7"
OR
(dbo_MG_SERVICE.LINE_CD)="P9"
OR
(dbo_MG_SERVICE.LINE_CD)="P5"
OR
(dbo_MG_SERVICE.LINE_CD)="PA")
AND
((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD])
AND
((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD])
AND
((dbo_MG_BL_ITINERARY.LEG_CD)="W"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)<>"MF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"EF"
AND
(dbo_MG_SERVICE.LINE_CD) Not Like "T*")
AND
((dbo_MG_LOCATION.COUNTRY_CD)="ES")
AND
((dbo_MG_LOCATION_1.COUNTRY_CD)<>"ES"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)<>"MF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"EF"
AND
(dbo_MG_SERVICE.LINE_CD) Not Like "T*")
AND
((dbo_MG_LOCATION.COUNTRY_CD)<>"ES")
AND
((dbo_MG_LOCATION_1.COUNTRY_CD)="ES"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)<>"MF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"EF"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)<>"MF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"EF"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="IMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)<>"MF"
AND
(dbo_MG_SERVICE.LINE_CD)<>"EF"
AND
(dbo_MG_SERVICE.LINE_CD) Not Like "T*")
AND
((dbo_MG_LOCATION.COUNTRY_CD)<>"ES")
AND
((dbo_MG_LOCATION_1.COUNTRY_CD)<>"ES"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ISWA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="IE"
OR
(dbo_MG_SERVICE.LINE_CD)="A4")
AND
((dbo_MG_LOCATION_2.COUNTRY_CD)=[dbo_MG_LOCATION]![COUNTRY_CD])
AND
((dbo_MG_LOCATION_3.COUNTRY_CD)=[dbo_MG_LOCATION_1]![COUNTRY_CD]))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="ASA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="SWA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="ASA"
OR
(dbo_MG_LOCATION.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_BL_ITINERARY.TO_LOCATION_CD)="EGAIS"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASASWA")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA"
OR
(dbo_MG_LOCATION_1.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_BL_ITINERARY.FROM_LOCATION_CD)="EGAIS"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.POR_LOCATION_CD)="SAJED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="A4"
OR
(dbo_MG_SERVICE.LINE_CD)="A2"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.PDL_LOCATION_CD)="SAJED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="A4"
OR
(dbo_MG_SERVICE.LINE_CD)="A2"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="ASA"
OR
(dbo_MG_LOCATION.CONTINENT_CD)="SWA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="NAM")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="SN"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAUSEC")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="NAM")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA"
OR
(dbo_MG_LOCATION_1.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="SN"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="ASA"
OR
(dbo_MG_LOCATION.CONTINENT_CD)="SWA")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="MED")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="SN"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_BILL_OF_LADING.TRADE_CD)="ASAMED")
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="MED")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="ASA"
OR
(dbo_MG_LOCATION_1.CONTINENT_CD)="SWA")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="SN"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="EUR")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="LAM")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="S2"
OR
(dbo_MG_SERVICE.LINE_CD)="U1"
OR
(dbo_MG_SERVICE.LINE_CD)="U2"))
OR
(((dbo_MG_BILL_OF_LADING.CREATE_DT)>=[Forms]![TS_FRT]![Date])
AND
((dbo_MG_SERVICE.VESSEL_TYPE_CD)="CONT")
AND
((dbo_MG_LOCATION.CONTINENT_CD)="LAM")
AND
((dbo_MG_LOCATION_1.CONTINENT_CD)="EUR")
AND
((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N")
AND
((dbo_MG_SERVICE.LINE_CD)="S2"
OR
(dbo_MG_SERVICE.LINE_CD)="U1"
OR
(dbo_MG_SERVICE.LINE_CD)="U2"));

I've only been doing this stuff for 15+ years, but have to say I've never seen anything like it!
I'm surprised it doesn't cause your computer to burst into flames.

Bob

Thanks for the formatting Bob... Is there an easy way to do that (automatically)?
If i had a PC it might burst into flames.. but I have an awful thin client instead.
For the record, can I say Ive been given this query and told to use it... I didnt make it myself... and theres 35 of them that run 1 after the other. When I have a spare month I will try to make it a bit easier.

Alisa - Thanks, im trying your plan... but its taking an age - will revert with the outcome soon (I hope).

Thanks for the formatting Bob... Is there an easy way to do that (automatically)?
If i had a PC it might burst into flames.. but I have an awful thin client instead.
For the record, can I say Ive been given this query and told to use it... I didnt make it myself... and theres 35 of them that run 1 after the other. When I have a spare month I will try to make it a bit easier.

Alisa - Thanks, im trying your plan... but its taking an age - will revert with the outcome soon (I hope).


A spare MONTH? You must be dreaming :). Good luck - my suggestions may not have any merit, but I find that if you just keep trying different things, eventually you will figure out what the problem is and find a way to get it working.

Sadly the Append option causes the same crash... I think the memory is OK. Its very odd.

Sadly the Append option causes the same crash... I think the memory is OK. Its very odd.

Ok, I have one more (probably silly) suggestion. Save your query as a select query. Then do a make table query based on your select query. What happens?

I thought that was a good idea!... but sadly it failed too :(
For some reason, when I tried that idea as a SELECT query it said "ODBC -- Call Failed". I checkd and all my ODBC links are still there and active... Im starting to hate Access.

I thought that was a good idea!... but sadly it failed too :(
For some reason, when I tried that idea as a SELECT query it said "ODBC -- Call Failed". I checkd and all my ODBC links are still there and active... Im starting to hate Access.


Don't hate Access, hate whoever designed that ridiculous query :D

Sounds like your days of simplifying are coming sooner than you expected - although maybe someone who knows more than me will pop in with a suggestion.

Well thank you for all your help... it was all worth trying.

Well thank you for all your help... it was all worth trying.

Well, here is my last suggestion - can you post your whole database? I could try running the query and see if it crashes on my computer too . . .

You mentioned ODBC... what is the backend?

Are there any memo/OLE/binary/any weird datatype involved in that query?

As for the query, how many rows do you expect it to return?

Also, I would want to remove the WHERE clause, see if it runs. If it runs, then I'd start add one WHERE condition at a time. Run it, and if it succeed, add the next. Keep on going until you've crashed, then you know which one is the PITA.

HTH.

I still say you should try to simplify it in the manner I suggested back in post #14. Access probably wants to throw a "Query is too complex" error, but doesn't know that's the case.

When I run it as MAKE TABLE, the whole thing just crashes, closes, restarts, and makes a backup of the database. Its very odd. The table was orig called "DB_MOTHER_ASSIGN" but ive tried using other table names too... ones that already exist and ones that dont yet exist.

Are you deleting the oringinal table before you ask the DB to Make it again? In my experience you would usuaully use Make Table for a "temporary" table, otherwise the system will get confused when you keep trying to make a table with the same name. So, once the data has been processed maybe there should be something there to tell it to delete it?

You mentioned ODBC... what is the backend?

Are there any memo/OLE/binary/any weird datatype involved in that query?

As for the query, how many rows do you expect it to return?

Also, I would want to remove the WHERE clause, see if it runs. If it runs, then I'd start add one WHERE condition at a time. Run it, and if it succeed, add the next. Keep on going until you've crashed, then you know which one is the PITA.

HTH.

Good catch. Could be a data-type conversion problem

Yikes! Loads of replies all in one go!

Alisa - Thanks for the offer but I think my company would kill me if I did that.

Redneck - Ideally I would like to rework the query, but Im still learining and this was supposed to be a quick fix as its a busy time for me.

Banana - The number of rows returned depends on the date entered into the form... could be a few thousand or more. Im not sure about datatype - Im still quite novice compared to you guys on here. If i take the reference to the form out of the query, it works as a MAKE TABLE query. With the reference to the form in, it doesn't, however it does work as a SELECT query. Ill try deleting the whole table before running the query...

Deleting the table then running the query also failed :(

An idea:

Do a SELECT query with the form reference.

*THEN* make a new Make Table query referencing the SELECT query. See if it works.

He tried that already :)

Alisa - Thanks for the offer but I think my company would kill me if I did that.



Oh well, it was worth a shot.

Hmm, so he did. But he said that SELECT query failed with "ODBC -- call failed" and now he says it works?

LB79, can you clarify? Does SELECT query works without raising that "ODBC -- call failed"?

If you're doing it from a form's button or something like that, add those lines to the line after where you call the query:

Dim i as integer
For i = 0 to DAO.Errors.Count-1
Debug.print DAO.Errors(i).Number
Debug.Print DAO.Errors(i).Description
Next i

NOTE: Not sure if Description is correct; check the intellisense to make sure it's spelled right or something like that.

HTH.

Hello…
When I use the SELECT query… it works.
When I use a SELECT query, then reference it in a MAKE TABLE query, it says "ODBC -- call failed".
I added those lines to the VB but it still crashed as normal.
I don’t know what intellisense is – sorry.

Thanks

Instellisense is the name for that popup menu that appears when you're typing stuff and helps you select the right syntax from a list.

I forgot one important thing- put in a breakpoint before the line where you do the MAKE TABLE query, then press F8 to step through the code one by one so we can get the error information.

Normally, when ODBC call fails, there should be another popup with the error message from the backend, but this doesn't appear if you've either implemented error handling or running it from VBA. For the latter case, you would need those lines I gave you to retrieve the extra errors.

I have a suspicion that there's not enough privileges and thus source of the failure but we will need to know the exact error from the backend to be sure.

If you go back to your original problem of Access crashing and backing itself up, it sounds like a problem I had a while ago.
I'm not sure it's related in your case, but do you have the Name Autocorrect turned on?
This will give you more information:
http://allenbrowne.com/bug-03.html

hi - Thanks for the suggestion... but it still crashes...