Help With SQL Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

At the end of my SQL Query I try to put the information in policy order.

I get this error message: Syntax error (missing operator) in query
expression 'ORDER BY dbo_grp_project.Policy".
 
OK, but it's a big one.

SELECT dbo_grp_project.Policy, dbo_grp_project.Comp,
dbo_grp_project.Curr_stat, dbo_grp_project.Tm,
[Group_Rating_Tier_Table].[Grp_TM%], dbo_grp_project.Manual,
dbo_grp_project.Baserate, dbo_grp_project.Mod_rate, Round(([Grp
TM%]+1)*[Baserate],2) AS GRP_RATE, dbo_grp_project.Admin_cost,
Round([GRP_RATE]*0.1526,4) AS GRPADMIN_COST, dbo_grp_project.Dwrf_tax,
dbo_grp_project.Dwrf_Addl, [Dwrf_tax]+[Dwrf_addl] AS DWRF,
Mod_rate]+[Admin_cost]+[Dwrf] AS TOTAL_RATE, GRP_RATE]+[GRPADMIN_COST]+[Dwrf]
AS GRPTOTAL_RATE, dbo_grp_project.Proll_curr, dbo_grp_project.Iproj_prem,
Round(([Proll_curr]*[GRPTOTAL_RATE])/100) AS GPROJ_PREM,
dbo_grp_project!IProj_prem-[GPROJ_PREM] AS PROJECTED_SAVE,
dbo_grp_project.Loss_ratio, dbo_grp_project.Ind_prj,
[Group_Rating_Tier_Table].[Ind_Grp], [Group_Rating_Tier_Table].[Begin_Ratio],
[Group_Rating_Tier_Table].[End_Ratio],
[Group_Rating_Tier_Table].[Group_Code],
dbo_grp_project, [Group_Rating_Tier_Table].[Fee%],
[Group_Rating_Tier_Table].[Sponsoring_Assn],
[Group_Rating_Tier_Table].[Sponsoring_Rep],
[Group_Rating_Tier_Table].[PROJECTED_SAVE]*[Fee %] AS MgmtFee,
IIf(dbo_grp_project!Ind_prj="10",IIf([MgmtFee]<=25,[MgmtFee]=25,[MgmtFee]),IIf([MgmtFee]<=75,[MgmtFee]=75,[MgmtFee])) AS MgmtFee1,
dbo_grp_project.Tpa_rep, dbo_wc1.notes, Round([MgmtFee]+0.000001,0) AS
MgmtFee2, ([MgmtFee2] Mod 2) AS [Odd-Even?],
IIf([Odd-Even?]=1,[MgmtFee2]+1,[MgmtFee2]) AS MgmtFee3,
dbo_grp_project.Referred,
dbo_grp_project.Proj_date, dbo_grp_project.Location, WHERE
(((dbo_grp_project.Policy)="01340620-000") AND
(([Group_Rating_Tier_Table].[Ind_Grp])=[dbo_grp_project]![Ind_prj]) AND
(([Group_Rating_Tier_Table].[Begin_Ratio])<=[dbo_grp_project]![Loss_ratio])
AND (([Group_Rating_Tier_Table].[End_Ratio])>=[dbo_grp_project]![Loss_ratio])
AND ((dbo_grp_project.Grp)="1" Or (dbo_grp_project.Grp)="2" Or
(dbo_grp_project.Grp)="3" Or (dbo_grp_project.Grp)="4" Or
(dbo_grp_project.Grp)="5" Or (dbo_grp_project.Grp)="6" Or
(dbo_grp_project.Grp)="7" Or (dbo_grp_project.Grp)="8" Or
(dbo_grp_project.Grp)="9" Or (dbo_grp_project.Grp)="10" Or
(dbo_grp_project.Grp)="11" Or (dbo_grp_project.Grp)="12" Or
(dbo_grp_project.Grp)="13" Or (dbo_grp_project.Grp)="14" Or
(dbo_grp_project.Grp)="15" Or (dbo_grp_project.Grp)="16" Or
(dbo_grp_project.Grp)="17" Or (dbo_grp_project.Grp)="18" Or
(dbo_grp_project.Grp)="19" Or (dbo_grp_project.Grp)="41" Or
(dbo_grp_project.Grp)="42" Or (dbo_grp_project.Grp)="43" Or
(dbo_grp_project.Grp)="44" Or (dbo_grp_project.Grp)="45" Or
(dbo_grp_project.Grp)="46" Or (dbo_grp_project.Grp)="47" Or
(dbo_grp_project.Grp)="48" Or (dbo_grp_project.Grp)="49" Or
(dbo_grp_project.Grp)="50" Or (dbo_grp_project.Grp)="51" Or
(dbo_grp_project.Grp)="52" Or (dbo_grp_project.Grp)="54" Or
(dbo_grp_project.Grp)="55" Or (dbo_grp_project.Grp)="55" Or
(dbo_grp_project.Grp)="56" Or (dbo_grp_project.Grp)="57" Or
(dbo_grp_project.Grp)="58"))
ORDER BY dbo_grp_project.Policy;
 
You have an extra comma in the SELECT clause - right before the WHERE clause
starts
You are missing an Opening square bracket in the line
Mod_rate]+[Admin_cost]+[Dwrf] AS TOTAL_RATE
You are missing an opening square bracket in the line ,
GRP_RATE]+[GRPADMIN_COST]+[Dwrf] AS GRPTOTAL_RATE
You don't have a FROM clause at all.

There are other errors in your code. Somehow, I don't think what you posted
ever ran.

SELECT dbo_grp_project.Policy
, dbo_grp_project.Comp
, dbo_grp_project.Curr_stat, dbo_grp_project.Tm
, [Group_Rating_Tier_Table].[Grp_TM%], dbo_grp_project.Manual
, dbo_grp_project.Baserate, dbo_grp_project.Mod_rate
, Round(([Grp TM%]+1)*[Baserate],2) AS GRP_RATE, dbo_grp_project.Admin_cost
, Round([GRP_RATE]*0.1526,4) AS GRPADMIN_COST, dbo_grp_project.Dwrf_tax
, dbo_grp_project.Dwrf_Addl
, [Dwrf_tax]+[Dwrf_addl] AS DWRF

, [Mod_rate]+[Admin_cost]+[Dwrf] AS TOTAL_RATE

, [GRP_RATE]+[GRPADMIN_COST]+[Dwrf] AS GRPTOTAL_RATE
, dbo_grp_project.Proll_curr, dbo_grp_project.Iproj_prem
, Round(([Proll_curr]*[GRPTOTAL_RATE])/100) AS GPROJ_PREM
, dbo_grp_project!IProj_prem-[GPROJ_PREM] AS PROJECTED_SAVE
, dbo_grp_project.Loss_ratio, dbo_grp_project.Ind_prj
, [Group_Rating_Tier_Table].[Ind_Grp]
, [Group_Rating_Tier_Table].[Begin_Ratio]
, [Group_Rating_Tier_Table].[End_Ratio]
, [Group_Rating_Tier_Table].[Group_Code]
, dbo_grp_project <<<<<<<<<<<<<<<<<<<< No field Name
, [Group_Rating_Tier_Table].[Fee%]
, [Group_Rating_Tier_Table].[Sponsoring_Assn],
[Group_Rating_Tier_Table].[Sponsoring_Rep],
[Group_Rating_Tier_Table].[PROJECTED_SAVE]*[Fee %] AS MgmtFee,
IIf(dbo_grp_project!Ind_prj="10",IIf([MgmtFee]<=25,[MgmtFee]=25,[MgmtFee]),IIf([MgmtFee]<=75,[MgmtFee]=75,[MgmtFee]))
AS MgmtFee1,
dbo_grp_project.Tpa_rep, dbo_wc1.notes, Round([MgmtFee]+0.000001,0) AS
MgmtFee2
, ([MgmtFee2] Mod 2) AS [Odd-Even?]
, IIf([Odd-Even?]=1,[MgmtFee2]+1,[MgmtFee2]) AS MgmtFee3
, dbo_grp_project.Referred
, dbo_grp_project.Proj_date
, dbo_grp_project.Location

, <<<<<<< Extra COMMA here >>>>>

WHERE
(((dbo_grp_project.Policy)="01340620-000") AND
(([Group_Rating_Tier_Table].[Ind_Grp])=[dbo_grp_project]![Ind_prj]) AND
(([Group_Rating_Tier_Table].[Begin_Ratio])<=[dbo_grp_project]![Loss_ratio])
AND
(([Group_Rating_Tier_Table].[End_Ratio])>=[dbo_grp_project]![Loss_ratio])
AND ((dbo_grp_project.Grp)="1" Or (dbo_grp_project.Grp)="2" Or
(dbo_grp_project.Grp)="3" Or (dbo_grp_project.Grp)="4" Or
(dbo_grp_project.Grp)="5" Or (dbo_grp_project.Grp)="6" Or
(dbo_grp_project.Grp)="7" Or (dbo_grp_project.Grp)="8" Or
(dbo_grp_project.Grp)="9" Or (dbo_grp_project.Grp)="10" Or
(dbo_grp_project.Grp)="11" Or (dbo_grp_project.Grp)="12" Or
(dbo_grp_project.Grp)="13" Or (dbo_grp_project.Grp)="14" Or
(dbo_grp_project.Grp)="15" Or (dbo_grp_project.Grp)="16" Or
(dbo_grp_project.Grp)="17" Or (dbo_grp_project.Grp)="18" Or
(dbo_grp_project.Grp)="19" Or (dbo_grp_project.Grp)="41" Or
(dbo_grp_project.Grp)="42" Or (dbo_grp_project.Grp)="43" Or
(dbo_grp_project.Grp)="44" Or (dbo_grp_project.Grp)="45" Or
(dbo_grp_project.Grp)="46" Or (dbo_grp_project.Grp)="47" Or
(dbo_grp_project.Grp)="48" Or (dbo_grp_project.Grp)="49" Or
(dbo_grp_project.Grp)="50" Or (dbo_grp_project.Grp)="51" Or
(dbo_grp_project.Grp)="52" Or (dbo_grp_project.Grp)="54" Or
(dbo_grp_project.Grp)="55" Or (dbo_grp_project.Grp)="55" Or
(dbo_grp_project.Grp)="56" Or (dbo_grp_project.Grp)="57" Or
(dbo_grp_project.Grp)="58"))
ORDER BY dbo_grp_project.Policy;



Novice2000 said:
OK, but it's a big one.

SELECT dbo_grp_project.Policy, dbo_grp_project.Comp,
dbo_grp_project.Curr_stat, dbo_grp_project.Tm,
[Group_Rating_Tier_Table].[Grp_TM%], dbo_grp_project.Manual,
dbo_grp_project.Baserate, dbo_grp_project.Mod_rate, Round(([Grp
TM%]+1)*[Baserate],2) AS GRP_RATE, dbo_grp_project.Admin_cost,
Round([GRP_RATE]*0.1526,4) AS GRPADMIN_COST, dbo_grp_project.Dwrf_tax,
dbo_grp_project.Dwrf_Addl, [Dwrf_tax]+[Dwrf_addl] AS DWRF,
Mod_rate]+[Admin_cost]+[Dwrf] AS TOTAL_RATE,
GRP_RATE]+[GRPADMIN_COST]+[Dwrf]
AS GRPTOTAL_RATE, dbo_grp_project.Proll_curr, dbo_grp_project.Iproj_prem,
Round(([Proll_curr]*[GRPTOTAL_RATE])/100) AS GPROJ_PREM,
dbo_grp_project!IProj_prem-[GPROJ_PREM] AS PROJECTED_SAVE,
dbo_grp_project.Loss_ratio, dbo_grp_project.Ind_prj,
[Group_Rating_Tier_Table].[Ind_Grp],
[Group_Rating_Tier_Table].[Begin_Ratio],
[Group_Rating_Tier_Table].[End_Ratio],
[Group_Rating_Tier_Table].[Group_Code],
dbo_grp_project, [Group_Rating_Tier_Table].[Fee%],
[Group_Rating_Tier_Table].[Sponsoring_Assn],
[Group_Rating_Tier_Table].[Sponsoring_Rep],
[Group_Rating_Tier_Table].[PROJECTED_SAVE]*[Fee %] AS MgmtFee,
IIf(dbo_grp_project!Ind_prj="10",IIf([MgmtFee]<=25,[MgmtFee]=25,[MgmtFee]),IIf([MgmtFee]<=75,[MgmtFee]=75,[MgmtFee]))
AS MgmtFee1,
dbo_grp_project.Tpa_rep, dbo_wc1.notes, Round([MgmtFee]+0.000001,0) AS
MgmtFee2, ([MgmtFee2] Mod 2) AS [Odd-Even?],
IIf([Odd-Even?]=1,[MgmtFee2]+1,[MgmtFee2]) AS MgmtFee3,
dbo_grp_project.Referred,
dbo_grp_project.Proj_date, dbo_grp_project.Location, WHERE
(((dbo_grp_project.Policy)="01340620-000") AND
(([Group_Rating_Tier_Table].[Ind_Grp])=[dbo_grp_project]![Ind_prj]) AND
(([Group_Rating_Tier_Table].[Begin_Ratio])<=[dbo_grp_project]![Loss_ratio])
AND
(([Group_Rating_Tier_Table].[End_Ratio])>=[dbo_grp_project]![Loss_ratio])
AND ((dbo_grp_project.Grp)="1" Or (dbo_grp_project.Grp)="2" Or
(dbo_grp_project.Grp)="3" Or (dbo_grp_project.Grp)="4" Or
(dbo_grp_project.Grp)="5" Or (dbo_grp_project.Grp)="6" Or
(dbo_grp_project.Grp)="7" Or (dbo_grp_project.Grp)="8" Or
(dbo_grp_project.Grp)="9" Or (dbo_grp_project.Grp)="10" Or
(dbo_grp_project.Grp)="11" Or (dbo_grp_project.Grp)="12" Or
(dbo_grp_project.Grp)="13" Or (dbo_grp_project.Grp)="14" Or
(dbo_grp_project.Grp)="15" Or (dbo_grp_project.Grp)="16" Or
(dbo_grp_project.Grp)="17" Or (dbo_grp_project.Grp)="18" Or
(dbo_grp_project.Grp)="19" Or (dbo_grp_project.Grp)="41" Or
(dbo_grp_project.Grp)="42" Or (dbo_grp_project.Grp)="43" Or
(dbo_grp_project.Grp)="44" Or (dbo_grp_project.Grp)="45" Or
(dbo_grp_project.Grp)="46" Or (dbo_grp_project.Grp)="47" Or
(dbo_grp_project.Grp)="48" Or (dbo_grp_project.Grp)="49" Or
(dbo_grp_project.Grp)="50" Or (dbo_grp_project.Grp)="51" Or
(dbo_grp_project.Grp)="52" Or (dbo_grp_project.Grp)="54" Or
(dbo_grp_project.Grp)="55" Or (dbo_grp_project.Grp)="55" Or
(dbo_grp_project.Grp)="56" Or (dbo_grp_project.Grp)="57" Or
(dbo_grp_project.Grp)="58"))
ORDER BY dbo_grp_project.Policy;

John Spencer said:
That bit looks OK, but you really need to post the entire SQL statement.
Click to expand...
Click to expand...
 
Back
Top