Help with sqlstring

I need some help with the particulars on this sql statement.

Here is the current statement I have writen up.

"SELECT D.ad_DispatchID, D.ad_Pickuptime, D.ad_Readytime, D.ad_Calltime, D.ad_Dispatchtime, D.ad_From, D.ad_Fromaddy, D.ad_Fromaddy2, D.ad_To, D.ad_Toaddy, D.ad_Toaddy2, D.ad_HAWB, D.ad_Move, D.ad_Trip, D.ad_Pieces, D.ad_Weight, D.ad_Vehicle, D.ad_Who, D.ad_Customer, D.ad_Dispatcher, D.ad_Arrival, D.ad_PODtime, D.ad_PODto, D.ad_Notes, D.ad_Signature, D.ad_Rate, D.ad_DriverID, D.ad_Confby, D.ad_Charges, D.ad_DispatchDate, S.ds_Total, P.di_Full, P.di_Cell, P.di_Home FROM (Dispatches D LEFT JOIN Statuses S ON (D.ad_DriverID = S.ds_DriverID) ) LEFT JOIN Driver P ON D.ad_DriverID = P.di_DriverID"

Here is what I am trying to change to.

"SELECT D.ad_DispatchID, D.ad_Pickuptime, D.ad_Readytime, D.ad_Calltime, D.ad_Dispatchtime, D.ad_From, D.ad_Fromaddy, D.ad_Fromaddy2, D.ad_To, D.ad_Toaddy, D.ad_Toaddy2, D.ad_HAWB, D.ad_Move, D.ad_Trip, D.ad_Pieces, D.ad_Weight, D.ad_Vehicle, D.ad_Who, D.ad_Customer, D.ad_Dispatcher, D.ad_Arrival, D.ad_PODtime, D.ad_PODto, D.ad_Notes, D.ad_Signature, D.ad_Rate, D.ad_DriverID, D.ad_Confby, D.ad_Charges, D.ad_DispatchDate, S.ds_Total, P.di_Full, P.di_Cell, P.di_Home, C.ci_Fullname FROM (Dispatches D LEFT JOIN Statuses S ON (D.ad_DriverID = S.ds_DriverID) ) LEFT JOIN Driver P ON D.ad_DriverID = P.di_DriverID LEFT JOIN Customer C ON D.ad_Customer = C.ci_Customer"

Access needs a series of brackets that I dont know how to arrange for three left joins

rudy
http://r937.com/