Repost For John Vinson

[cvegas]

Did not know if you would find this if I went to the old post so did it this
way.

Here is the SQL statement for the make table query that is not working.

SELECT FindUpdatedOrders.LastUpdate, FindUpdatedOrders.LastSend,
FindUpdatedOrders.OrderID, FindUpdatedOrders.[Type of Order],
FindUpdatedOrders.[Order Date], FindUpdatedOrders.CusNum,
FindUpdatedOrders.Area, FindUpdatedOrders.Weight,
FindUpdatedOrders.WeightChg, FindUpdatedOrders.[Drop or Delivery Date],
FindUpdatedOrders.SpecialType, FindUpdatedOrders.SpecialChg,
FindUpdatedOrders.Pieces, FindUpdatedOrders.[AirPort Code],
FindUpdatedOrders.[Pick Up or Delivery Company], FindUpdatedOrders.[Pick Up
or Delivery Address], FindUpdatedOrders.[Pick Up or Delivery Suite],
FindUpdatedOrders.[Pick Up or Delivery City], FindUpdatedOrders.[Pick Up or
Delivery State], FindUpdatedOrders.[Pick Up or Delivery Zip],
FindUpdatedOrders.[Pick Up or Delivery Contact], FindUpdatedOrders.[Pick Up
or Delivery Phone], FindUpdatedOrders.[Ready Time], FindUpdatedOrders.[Close
Time], FindUpdatedOrders.[Order Notes], FindUpdatedOrders.[Carrier Code],
FindUpdatedOrders.[Carrier BL #], FindUpdatedOrders.[ETA or Pickup Date],
FindUpdatedOrders.[ETA Carrier Arrive Depart Time], FindUpdatedOrders.[1st
Flight Number], FindUpdatedOrders.[Connecting Flight #],
FindUpdatedOrders.[Connecting Flight APCode], FindUpdatedOrders.[Where To or
From], FindUpdatedOrders.[Forwarder Airline Acct #],
FindUpdatedOrders.[Special Commodity Ref #], FindUpdatedOrders.[Type of
Carrier Service], FindUpdatedOrders.[Routing Type],
FindUpdatedOrders.[Special Requested], FindUpdatedOrders.Custref,
FindUpdatedOrders.[POD Date], FindUpdatedOrders.[POD Time],
FindUpdatedOrders.[POD Signature], FindUpdatedOrders.[Notify With POD],
FindUpdatedOrders.[POD Preference], FindUpdatedOrders.[POD Sent],
FindUpdatedOrders.[Order Status], FindUpdatedOrders.[Needs Authorization],
FindUpdatedOrders.[Authorization Number], FindUpdatedOrders.ConvCtrName,
FindUpdatedOrders.UsingDims, FindUpdatedOrders.Invoiced,
FindUpdatedOrders.InvoiceNumber, FindUpdatedOrders.SRQ,
FindUpdatedOrders.Paid, FindUpdatedOrders.AmountApplied,
FindUpdatedOrders.OrderTotal, FindUpdatedOrders.HistoryOnly INTO OrdersUpdate
IN 'f:\CSVFiles\WebUpdate.mdb'
FROM FindUpdatedOrders;

I have tried this using a make table in the current database and it does not
work their either.?