How to resolve the NULL value from SQL ?

[cheer]

My system prompt the error :
DATA TYPE MISMATCH IN CRITERIA EXPRESSION

How to know which fields contribute to the problem above? My SQL statement is as following

insert into Master_Drawing_Comparison (ModuleNo,DrawingNo,Description,Operator,StandardOrFabrication,StandardQty,BalanceQty,UOM,RackNo,Currency1,SellingPrice,BuyingPrice,AdminTransportCost,AssemblyCost,Supplier,ManufacturingPartNo,LastUpdateDate)select ModuleNo,DrawingNo,Description,'00477',Type,SumOfStandardQty,BalanceQty,UOM,RackNo,Currency1,SellingPrice,BuyingPrice,AdminTransportCost,AssemblyCost,Supplier,ManufacturingPartNo,LastUpdateDate from V_Master_Drawing_Comparison2 where ModuleNo='2380910'

Any expert here can advise me something ?

 

[Galaxiom]

Criteria expression is the WHERE so I expect ModuleNo is a number so should not be quoted as a string.

Seems an odd thing to be adding records from one table to another.

Also note that code should be posted in a code box by including code tags. This preserves formatting making it much easier to read.

http://www.access-programmers.co.uk/forums/showthread.php?goto=newpost&t=200247