請問各位大大 這是我的語法 select compname,sum(prodcount) as sum_count,sum(total) as Sum_Money from accounting where compname='原智' and saledate='2003/6/10' group by compname 他會出現準則運算式的資料類型不符合的錯誤訊息 但是如果把 and saledate='2003/6/10' 這行去掉就正常 請問這行該如何寫才對

你好： Access 的日期數值左右邊要使用 # 符號包起來 < class="code"> select compname,sum(prodcount) as sum_count,sum(total) as Sum_Money from accounting where compname='原智' and saledate='#2003/6/10#' group by compname

select compname,sum(prodcount) as sum_count,sum(total) as Sum_Money from accounting where compname='原智' and saledate=#2003/6/10# group by compname 日期型態條件在Access要使用#日期#來包住....