Here is the SQL Statment I am trying to execute. This statement runs fine in Access.
SELECT load.date, load.waybillnum, route.start, route.end, load.hrlyhauls, load.correctedvolume, load.addwork, route.riser, load.comments, driver.fname, driver.lname, load.wage, load.driverindex, (select unit...