Hello,
Im having problems with a query.
Ive created the query which works great as a select query, but for some
reason if I change it to a Make Table Query, it says Invalid Argument. The table its trying to make doesn't exist. Ive tried making a table and trying an Append query too and I get the same error. When I change the query back to Select, it works as normal again.
Can anyone see what im doing wrong?

Thanks :)

post the sql of query

Sorry - didnt think to do that...

This is the Select query which works...
SELECT dbo_MG_VESSEL_SCHEDULE.VESSEL_CD, dbo_MG_VESSEL_SCHEDULE.VOYAGE_CD, dbo_MG_VESSEL_SCHEDULE.LEG_CD, dbo_MG_BILL_OF_LADING.BL_PREFIX_CD, dbo_MG_BILL_OF_LADING.BL_NUM, dbo_MG_BILL_OF_LADING.BL_TYPE_CD, dbo_MG_BILL_OF_LADING.BL_ISSUE_OFFICE_CD, dbo_MG_BILL_OF_LADING.DELETED_FLG, Format(dbo_MG_BILL_OF_LADING!CREATE_DT,"YYYYMMDD") AS [CREATE DT YMD], dbo_MG_LOCATION.CONTINENT_CD, dbo_MG_VESSEL.VESSEL_TYPE_CD, DB_BLPREFIX2a.CTM_AGENT
FROM ((((dbo_MG_BILL_OF_LADING LEFT JOIN dbo_MG_VESSEL ON dbo_MG_BILL_OF_LADING.VESSEL_CD = dbo_MG_VESSEL.VESSEL_CD) LEFT JOIN dbo_MG_BL_ITINERARY ON dbo_MG_BILL_OF_LADING.BL_ID = dbo_MG_BL_ITINERARY.BL_ID) LEFT JOIN dbo_MG_LOCATION ON dbo_MG_BILL_OF_LADING.POI_LOCATION_CD = dbo_MG_LOCATION.LOCATION_CD) LEFT JOIN DB_BLPREFIX2a ON dbo_MG_BILL_OF_LADING.POI_LOCATION_CD = DB_BLPREFIX2a.[BL ISSUE OFFICE]) LEFT JOIN dbo_MG_VESSEL_SCHEDULE ON dbo_MG_VESSEL.VESSEL_CD = dbo_MG_VESSEL_SCHEDULE.VESSEL_CD
WHERE (((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR" Or (dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_VESSEL.VESSEL_TYPE_CD)="CONT") AND ((Format([dbo_MG_BILL_OF_LADING]![CREATE_DT],"YYYYMMDD")) Between 20080501 And 20080502));

And this is the Make Table query version which doesn't:
SELECT dbo_MG_VESSEL_SCHEDULE.VESSEL_CD, dbo_MG_VESSEL_SCHEDULE.VOYAGE_CD, dbo_MG_VESSEL_SCHEDULE.LEG_CD, dbo_MG_BILL_OF_LADING.BL_PREFIX_CD, dbo_MG_BILL_OF_LADING.BL_NUM, dbo_MG_BILL_OF_LADING.BL_TYPE_CD, dbo_MG_BILL_OF_LADING.BL_ISSUE_OFFICE_CD, dbo_MG_BILL_OF_LADING.DELETED_FLG, Format(dbo_MG_BILL_OF_LADING!CREATE_DT,"YYYYMMDD") AS [CREATE DT YMD], dbo_MG_LOCATION.CONTINENT_CD, dbo_MG_VESSEL.VESSEL_TYPE_CD, DB_BLPREFIX2a.CTM_AGENT INTO Test
FROM ((((dbo_MG_BILL_OF_LADING LEFT JOIN dbo_MG_VESSEL ON dbo_MG_BILL_OF_LADING.VESSEL_CD = dbo_MG_VESSEL.VESSEL_CD) LEFT JOIN dbo_MG_BL_ITINERARY ON dbo_MG_BILL_OF_LADING.BL_ID = dbo_MG_BL_ITINERARY.BL_ID) LEFT JOIN dbo_MG_LOCATION ON dbo_MG_BILL_OF_LADING.POI_LOCATION_CD = dbo_MG_LOCATION.LOCATION_CD) LEFT JOIN DB_BLPREFIX2a ON dbo_MG_BILL_OF_LADING.POI_LOCATION_CD = DB_BLPREFIX2a.[BL ISSUE OFFICE]) LEFT JOIN dbo_MG_VESSEL_SCHEDULE ON dbo_MG_VESSEL.VESSEL_CD = dbo_MG_VESSEL_SCHEDULE.VESSEL_CD
WHERE (((dbo_MG_BILL_OF_LADING.DELETED_FLG)="N") AND ((dbo_MG_LOCATION.CONTINENT_CD)="EUR" Or (dbo_MG_LOCATION.CONTINENT_CD)="MED") AND ((dbo_MG_VESSEL.VESSEL_TYPE_CD)="CONT") AND ((Format([dbo_MG_BILL_OF_LADING]![CREATE_DT],"YYYYMMDD")) Between 20080501 And 20080502));

Thanks

can you show me your table structure with some little data
Upload sample if possible