| Author |
Topic |
|
baansuan
Starting Member
2 Posts |
 Posted - 2007-07-09 : 03:06:39
|
| In MS Basic, I try to add one field_name (prepared_date) into command "select" and it has error "You tried to execute a query that doesn't include the specified expression "prepared_date" as part of an aggregated function. cSql = cSql & " SELECT a.id_no, b.staff_name, b.init, a.projectname,a.prepared_by " cSql = cSql & " sum(iif([awareness]=10,1,0)) as aw10," cSql = cSql & " sum(iif([awareness]=9,1,0)) as aw9," cSql = cSql & " sum(iif([awareness]=8,1,0)) as aw8," cSql = cSql & " sum(iif([awareness]=7,1,0)) as aw7," cSql = cSql & " sum(iif([awareness]=6,1,0)) as aw6," cSql = cSql & " sum(iif([awareness]=5,1,0)) as aw5," cSql = cSql & " sum(iif([awareness]=4,1,0)) as aw4," cSql = cSql & " sum(iif([awareness]=3,1,0)) as aw3," cSql = cSql & " sum(iif([awareness]=2,1,0)) as aw2," cSql = cSql & " sum(iif([awareness]=1,1,0)) as aw1," cSql = cSql & " sum(iif([attempt]=10,1,0)) as at10," cSql = cSql & " sum(iif([attempt]=9,1,0)) as at9," cSql = cSql & " sum(iif([attempt]=8,1,0)) as at8," cSql = cSql & " sum(iif([attempt]=7,1,0)) as at7," cSql = cSql & " sum(iif([attempt]=6,1,0)) as at6," cSql = cSql & " sum(iif([attempt]=5,1,0)) as at5," cSql = cSql & " sum(iif([attempt]=4,1,0)) as at4," cSql = cSql & " sum(iif([attempt]=3,1,0)) as at3," cSql = cSql & " sum(iif([attempt]=2,1,0)) as at2," cSql = cSql & " sum(iif([attempt]=1,1,0)) as at1," cSql = cSql & " sum(iif([achievement]=10,1,0)) as ac10," cSql = cSql & " sum(iif([achievement]=9,1,0)) as ac9," cSql = cSql & " sum(iif([achievement]=8,1,0)) as ac8," cSql = cSql & " sum(iif([achievement]=7,1,0)) as ac7," cSql = cSql & " sum(iif([achievement]=6,1,0)) as ac6," cSql = cSql & " sum(iif([achievement]=5,1,0)) as ac5," cSql = cSql & " sum(iif([achievement]=4,1,0)) as ac4," cSql = cSql & " sum(iif([achievement]=3,1,0)) as ac3," cSql = cSql & " sum(iif([achievement]=2,1,0)) as ac2," cSql = cSql & " sum(IIf([achievement] = 1, 1, 0)) As ac1" cSql = cSql & " FROM tbl_Appriasal a " cSql = cSql & " INNER JOIN tblSTAFF_MASTER b on a.id_no = b.id_no"I have rechecked the table "tbl_appraisal" and found this field "prepared_date". Well I really don't know what I do wrong. Any one can help me,please?Thanks. |
|
|
baansuan
Starting Member
2 Posts |
Posted - 2007-07-09 : 03:12:19
|
| sorry the line of select command iscSql = cSql & " SELECT a.id_no, b.staff_name, b.init, a.projectname,a.prepared_by, a.PREPARED_DATE, "Pls ignore the previous command line |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-07-09 : 05:11:52
|
| In the group by clause you need to add prepared_date columnMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Error "You tried to execute a query that ...