|
List Info
Thread: -=(ASP-Support-Group)=- Error on Award_No field
|
|
| -=(ASP-Support-Group)=- Error on
Award_No field |
|
2006-05-12 15:44:39 |
|
Set rs = con.Execute("SELECT E.Name1 as ss, E.Award1 as kk, (SELECT Count(*)
from Award Where Name1 = E.Name1 and Award_No =
E.Award_No) as cc FROM Award E where E.Award_Date >= #" & date1 & "# and
E.Award_Date <= #" & date2 & "# GROUP BY
E.Award1,E.Name1, award_no")
Tony Work.
----- Original Message -----
From: "Kathy Iwasik" <girl_moon_godessyahoo.com>
To: <ASP-Support-Group@yahoogroups.com>
Sent: Friday, May 12, 2006 4:26 PM
Subject: -=(ASP-Support-Group)=- Error on Award_No field
Set rs = con.Execute("SELECT E.Name1 as ss, E.Award1 as kk, (SELECT Count(*)
from Award Where Name1 = E.Name1 and Award_No =
E.Award_No) as cc FROM Award E where E.Award_Date >= #" & date1 & "# and
E.Award_Date <= #" & date2 & "# GROUP BY
E.Award1,E.Name1";)
; Script error detected at line 23.
Source line: Set rs = con.Execute("SELECT E.Name1 as ss, E.Award1 as kk,
(SELECT Count(*) from Award Where Name1 = E.Name1
and Award_No = E.Award_No) as cc FROM Award E where E.Award_Date >= #" &
date1 & "# and E.Award_Date <= #" & date2 & "# GROUP
BY E.Award1,E.Name1";)
Description: [Microsoft][ODBC Microsoft Access Driver] You tried to execute
a query that does not include the specified expression 'Award_No' as part of
an aggregate function.
---------------------------------
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
rates.
|
[1]
|
|
|
about | contact Other archives ( Real Estate discussion Medical topics )
|