I keep getting a syntex error mising operator

25 Feb 2005 2:17 AM

Alvin Smith

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!

25 Feb 2005 3:35 AM

Duane Hookom

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

--
Duane Hookom
MS Access MVP

Show quote

"Alvin Smith" <AlvinSm***@discussions.microsoft.com> wrote in message
news:04FD1E6D-4725-4037-829C-857C4C080BB3@microsoft.com...
>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!

25 Feb 2005 2:56 PM

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" <AlvinSm***@discussions.microsoft.com> wrote in message
news:04FD1E6D-4725-4037-829C-857C4C080BB3@microsoft.com...
> 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];
Show quote

>
> I don't know what I am missing Thanks in advance!