I keep getting a syntex error mising operator

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

Guest

I am trying to keep up with my hour with straight time over time double and
triple time. This is the expression I am using in my subform when I get the
message.

SELECT DISTINCTROW [Order Details].*,
Clng(([Rate]*[SThrs])+([Rate]*[OThrs]*1.5)+([Rate]*[DThrs]*2)+([Rate]*[TThrs]*3) AS [Line Total] FROM [Pay Hours subform];

I don't know what I am missing Thanks in advance!
 
How do you select [Order Details].* when your only table is [Pay Hours
subform]? Is Pay Hours subform a table or query?
 
I am not sure what you are trying to do with this SQL String (strange as per
Duane)but you have unbalanced parentheses. The number of opening
parentheses is one more than the number of closing parentheses. This is
likely to be the cause of the syntax error.

--
HTH
Van T. Dinh
MVP (Access)



Alvin Smith said:
I am trying to keep up with my hour with straight time over time double and
triple time. This is the expression I am using in my subform when I get the
message.

SELECT DISTINCTROW [Order Details].*,
Click to expand...
Clng(([Rate]*[SThrs])+([Rate]*[OThrs]*1.5)+([Rate]*[DThrs]*2)+([Rate]*[TThrs
]*3) AS [Line Total] FROM [Pay Hours subform];
 
Back
Top