I keep getting a syntex error mising operator

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!
 
D

Duane Hookom

How do you select [Order Details].* when your only table is [Pay Hours
subform]? Is Pay Hours subform a table or query?
 
V

Van T. Dinh

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].*,
Clng(([Rate]*[SThrs])+([Rate]*[OThrs]*1.5)+([Rate]*[DThrs]*2)+([Rate]*[TThrs
]*3) AS [Line Total] FROM [Pay Hours subform];
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top