数据类型不匹配表达式 [英] Data Type Mismatch Expression

问题描述

我正面临Data Mismatch Expresssion Error-3464。任何人都可以提供帮助吗？以下是代码：

  SELECT  Underwear_ProjectedAvailabilityPlanning_Xtab。*  INTO  Underwear_ProjectedAvailabilityPlanningTable 
  FROM  Underwear_ProjectedAvailabilityPlanning_Xtab 
  WHERE （（（nz（[FutReleases00]）+ nz（[FutReleases01]）+ nz（[FutReleases02]）+ nz（[FutReleases03]）+ nz（[FutReleases04]）+ nz（[FutReleases05]）+ nz（[ FutReleases06]）+ NZ（[FutReleases07]）+ NZ（[FutReleases08]）+ NZ（[FutReleases09]）+ NZ（[FutReleases10]）+ NZ（[FutReleases11]）+ NZ（[FutReleases12]）+ NZ（[ProdComplete00 ]）+ NZ（[ProdComplete01]）+ NZ（[ProdComplete02]）+ NZ（[ProdComplete03]）+ NZ（[ProdComplete04]）+ NZ（[ProdComplete05]）+ NZ（[ProdComplete06]）+ NZ（[ProdComplete07] ）+ NZ（[ProdComplete08]）+ NZ（[ProdComplete09]）+ NZ（[ProdComplete10]）+ NZ（[ProdComplete11]）+ NZ（[ProdComplete12]）+ NZ（[WO00]）+ NZ（[WO01]） + NZ（[WO02]）+ NZ（[WO03]）+ NZ（[WO04]）+ NZ（[WO05]）+ NZ（[WO06]）+ NZ（[WO07]）+ NZ（[WO08]）+新西兰（[WO09]）+ nz（[WO10]）+ nz（[WO11]）+ nz（[WO12]））> 0））; 

谢谢

解决方案

Nz（[WO11] ]）当值为Null时返回一个空字符串。

这不能与0（零）比较。



替换所有 Nz 表达式类似于：



Nz（[WO11]，0） ...

I'm facing Data Mismatch Expresssion Error- 3464. Can anyone help? Here is the code:

SELECT Underwear_ProjectedAvailabilityPlanning_Xtab.* INTO Underwear_ProjectedAvailabilityPlanningTable
FROM Underwear_ProjectedAvailabilityPlanning_Xtab
WHERE (((nz([FutReleases00])+nz([FutReleases01])+nz([FutReleases02])+nz([FutReleases03])+nz([FutReleases04])+nz([FutReleases05])+nz([FutReleases06])+nz([FutReleases07])+nz([FutReleases08])+nz([FutReleases09])+nz([FutReleases10])+nz([FutReleases11])+nz([FutReleases12])+nz([ProdComplete00])+nz([ProdComplete01])+nz([ProdComplete02])+nz([ProdComplete03])+nz([ProdComplete04])+nz([ProdComplete05])+nz([ProdComplete06])+nz([ProdComplete07])+nz([ProdComplete08])+nz([ProdComplete09])+nz([ProdComplete10])+nz([ProdComplete11])+nz([ProdComplete12])+nz([WO00])+nz([WO01])+nz([WO02])+nz([WO03])+nz([WO04])+nz([WO05])+nz([WO06])+nz([WO07])+nz([WO08])+nz([WO09])+nz([WO10])+nz([WO11])+nz([WO12]))>0));

Thanks

解决方案

Nz([WO11]) returns an empty string when the value is Null.
This cannot be compared with 0 (zero).

Replace all your Nz expressions with expressions similar to:

Nz([WO11], 0) ...

这篇关于数据类型不匹配表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！