[AccessD] FW: sql help please

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Sat Feb 4 00:14:31 CST 2006


I would copy the SQL of this query into the SQL view of a new query, 
then switch to design view.  A lot of times for me that shows up the 
error in my SQL statement.

Rocky


Joe Hecht wrote:
>  
>
> No takers so I am asking again.
>
> Joe Hecht
>
> jmhecht at earthlink.net
>
>   _____  
>
> From: Joe Hecht [mailto:jmhecht at earthlink.net] 
> Sent: Thursday, February 02, 2006 8:35 PM
> To: 'Access Developers discussion and problem solving'
> Subject: sql help please
>
>  
>
> I am having 1 issue with the statement below.
>
>  
>
> I have confirmed 20_stb_Loc_Wather_Road does indeed have
> data in it so we are not looking at null messing me up. ( I
> think)
>
>  
>
> When I run the query no data from the table
> 20_stb_Loc_Wather_Road is populating the query. I tried
> splitting the query into a second query with everything
> except the 20_stb_Loc_Wather_Road on one side and the
> 20_stb_Loc_Wather_Road fields as the second query source and
> I still had the same problem.
>
>  
>
> I will check in morning. Bed time for me now.
>
>  
>
>  
>
>  
>
> SELECT [10_tbl_PersonelMasterData].MyEmpNumb,
> [20_tblAIMaster].ACCIDENT,
> [20_tblAIMaster].MyAccidnetRecordNumber,
> [20_tblAIMaster].CLAIM AS ClaimNumber,
> [20_tblAIMaster].COMPANY, [20_tblAIMaster].AccidentDATE,
> [20_stblAccDayInfo].AccidentTime,
> [20_stblAccDayInfo].AccidentDayofWeek,
> [20_tblAIMaster].DRIV_NUM, [20_tblAIMaster].REP_DATE,
> [20_tblAIMaster].STATUS, [50_ltblTerminal].TRMNL_DESC,
> [10_stblEmpCompInfo].START_DATE,
> [20_tblAIMaster].OPEN_CLAIM, [last_NAME] & ", " &
> [First_Name] & " " & [Middle_Name] AS FName,
> [10_tbl_PersonelMasterData].DOB,
> [20_stb_Loc_Wather_Road].RoadCondition,
> [20_stb_Loc_Wather_Road].ROAD_TYPE,
> [20_stb_Loc_Wather_Road].WEATHER,
> [20_stb_Loc_Wather_Road].Loc_type,
> [20_stb_Loc_Wather_Road].Acc_type,
> [20_stb_Loc_Wather_Road].CHARGABIL
>
>  
>
> FROM (50_ltblTerminal RIGHT JOIN (10_tbl_PersonelMasterData
> INNER JOIN 10_stblEmpCompInfo ON
> [10_tbl_PersonelMasterData].MyEmpNumb =
> [10_stblEmpCompInfo].MyEmpNumb) ON
> [50_ltblTerminal].TRMNL_CODE =
> [10_stblEmpCompInfo].TERMINAL) INNER JOIN
> (20_stb_Loc_Wather_Road RIGHT JOIN ((20_tblAIMaster INNER
> JOIN 20_stblAccDayInfo ON
> [20_tblAIMaster].MyAccidnetRecordNumber =
> [20_stblAccDayInfo].MyAccidnetRecordNumber) INNER JOIN
> 20_stblAIPaidExpences ON
> [20_tblAIMaster].MyAccidnetRecordNumber =
> [20_stblAIPaidExpences].MyAccidnetRecordNumber) ON
> [20_stb_Loc_Wather_Road].MyAccidnetRecordNumber =
> [20_tblAIMaster].MyAccidnetRecordNumber) ON
> ([10_tbl_PersonelMasterData].DRIV_NUM =
> [20_tblAIMaster].DRIV_NUM) AND
> ([10_tbl_PersonelMasterData].DRIV_NUM =
> [20_tblAIMaster].DRIV_NUM);
>
>  
>
>  
>
> TIA
>
>  
>
> Joe Hecht
>
> jmhecht at earthlink.net
>
>  
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list